xref: /PHP-8.2/ext/oci8/tests/field_funcs3.phpt (revision 74859783)
1--TEST--
2oci_field_*() family: basic column types
3--EXTENSIONS--
4oci8
5--FILE--
6<?php
7
8require(__DIR__."/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);
18if (strpos($v, 'Oracle TimesTen') === false) {
19    oci8_test_sql_execute($c, array("alter session set nls_date_format = 'DD-MON-YYYY'"));
20}
21oci8_test_sql_execute($c, $stmtarray);
22
23// Run Test
24
25$select_sql = "select * from field_funcs3_tab";
26
27if (!($s = oci_parse($c, $select_sql))) {
28    die("oci_parse(select) failed!\n");
29}
30
31if (!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);
36var_dump($row);
37
38foreach ($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
55oci8_test_sql_execute($c, $stmtarray);
56
57?>
58--EXPECTF--
59array(4) {
60  [0]=>
61  string(2) "c1"
62  [1]=>
63  string(2) "c2"
64  [2]=>
65  string(1) "3"
66  [3]=>
67  string(1%r[19]%r) "%r(01-JAN-2010|0001-01-20 10:00:00)%r"
68}
69bool(false)
70string(4) "C1_C"
71string(4) "CHAR"
72int(96)
73int(0)
74int(0)
75int(2)
76bool(false)
77string(4) "C2_V"
78string(8) "VARCHAR2"
79int(1)
80int(0)
81int(0)
82int(2)
83bool(false)
84string(4) "C3_N"
85string(6) "NUMBER"
86int(2)
87int(-127)
88int(0)
89int(22)
90bool(false)
91string(4) "C4_D"
92string(4) "DATE"
93int(12)
94int(0)
95int(0)
96int(7)
97