Return to field_funcs3.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

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===