Return to define4.phpt CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/define4.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: oci_define_by_name() on partial number of columns
        !             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: // Initialize
        !            11: 
        !            12: $stmtarray = array(
        !            13:     "drop table define4_tab",
        !            14:     "create table define4_tab (value number, string varchar(10))",
        !            15:     "insert into define4_tab (value, string) values (1234, 'some')",
        !            16: );
        !            17: 
        !            18: oci8_test_sql_execute($c, $stmtarray);
        !            19: 
        !            20: // Run test
        !            21: 
        !            22: $stmt = oci_parse($c, "select value, string from define4_tab");
        !            23: 
        !            24: echo "Test 1\n";
        !            25: // Only one of the two columns is defined
        !            26: var_dump(oci_define_by_name($stmt, "STRING", $string));
        !            27: 
        !            28: oci_execute($stmt);
        !            29: 
        !            30: echo "Test 2\n";
        !            31: 
        !            32: while (oci_fetch($stmt)) {
        !            33:        var_dump(oci_result($stmt, 'VALUE'));
        !            34:        var_dump($string);
        !            35:        var_dump(oci_result($stmt, 'STRING'));
        !            36:        var_dump($string);
        !            37:        var_dump(oci_result($stmt, 'VALUE'));
        !            38:        var_dump(oci_result($stmt, 'STRING'));
        !            39: }
        !            40: 
        !            41: echo "Test 3\n";
        !            42: var_dump(oci_free_statement($stmt));
        !            43: var_dump($string);
        !            44: var_dump(oci_result($stmt, 'STRING'));
        !            45: 
        !            46: // Cleanup
        !            47: 
        !            48: $stmtarray = array(
        !            49:     "drop table define4_tab"
        !            50: );
        !            51: 
        !            52: oci8_test_sql_execute($c, $stmtarray);
        !            53: 
        !            54: echo "Done\n";
        !            55: 
        !            56: ?>
        !            57: --EXPECTF--
        !            58: Test 1
        !            59: bool(true)
        !            60: Test 2
        !            61: %unicode|string%(4) "1234"
        !            62: %unicode|string%(4) "some"
        !            63: %unicode|string%(4) "some"
        !            64: %unicode|string%(4) "some"
        !            65: %unicode|string%(4) "1234"
        !            66: %unicode|string%(4) "some"
        !            67: Test 3
        !            68: bool(true)
        !            69: %unicode|string%(4) "some"
        !            70: 
        !            71: Warning: oci_result(): %d is not a valid oci8 statement resource in %s on line %d
        !            72: bool(false)
        !            73: Done
        !            74: