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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>