Annotation of embedaddon/php/ext/oci8/tests/field_funcs3.phpt, revision 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>