Annotation of embedaddon/php/ext/oci8/tests/field_funcs3.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: oci_field_*() family: basic column types
3: --SKIPIF--
4: <?php if (!extension_loaded('oci8')) die ("skip no oci8 extension"); ?>
5: --FILE--
6: <?php
7:
8: require(dirname(__FILE__)."/connect.inc");
9:
10: // Initialization
11: $stmtarray = array(
12: "drop table field_funcs3_tab",
13: "create table field_funcs3_tab(c1_c char(2), c2_v varchar2(2), c3_n number, c4_d date)",
14: "insert into field_funcs3_tab values ('c1', 'c2', 3, '01-Jan-2010')"
15: );
16:
17: $v = oci_server_version($c);
18: if (strpos($v, 'Oracle TimesTen') === false) {
19: oci8_test_sql_execute($c, array("alter session set nls_date_format = 'DD-MON-YYYY'"));
20: }
21: oci8_test_sql_execute($c, $stmtarray);
22:
23: // Run Test
24:
25: $select_sql = "select * from field_funcs3_tab";
26:
27: if (!($s = oci_parse($c, $select_sql))) {
28: die("oci_parse(select) failed!\n");
29: }
30:
31: if (!oci_execute($s)) {
32: die("oci_execute(select) failed!\n");
33: }
34:
35: $row = oci_fetch_array($s, OCI_NUM + OCI_RETURN_NULLS + OCI_RETURN_LOBS);
36: var_dump($row);
37:
38: foreach ($row as $num => $field) {
39: $num++;
40: var_dump(oci_field_is_null($s, $num));
41: var_dump(oci_field_name($s, $num));
42: var_dump(oci_field_type($s, $num));
43: var_dump(oci_field_type_raw($s, $num));
44: var_dump(oci_field_scale($s, $num));
45: var_dump(oci_field_precision($s, $num));
46: var_dump(oci_field_size($s, $num));
47: }
48:
49: // Clean up
50:
51: $stmtarray = array(
52: "drop table field_funcs3_tab"
53: );
54:
55: oci8_test_sql_execute($c, $stmtarray);
56:
57: ?>
58: ===DONE===
59: <?php exit(0); ?>
60: --EXPECTF--
61: array(4) {
62: [0]=>
63: string(2) "c1"
64: [1]=>
65: string(2) "c2"
66: [2]=>
67: string(1) "3"
68: [3]=>
69: string(1%r[19]%r) "%r(01-JAN-2010|0001-01-20 10:00:00)%r"
70: }
71: bool(false)
72: string(4) "C1_C"
73: string(4) "CHAR"
74: int(96)
75: int(0)
76: int(0)
77: int(2)
78: bool(false)
79: string(4) "C2_V"
80: string(8) "VARCHAR2"
81: int(1)
82: int(0)
83: int(0)
84: int(2)
85: bool(false)
86: string(4) "C3_N"
87: string(6) "NUMBER"
88: int(2)
89: int(-127)
90: int(0)
91: int(22)
92: bool(false)
93: string(4) "C4_D"
94: string(4) "DATE"
95: int(12)
96: int(0)
97: int(0)
98: int(7)
99: ===DONE===
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>