Return to define6.phpt CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/define6.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: oci_define_by_name tests with REF CURSORs
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: // Initialization
                     14: 
                     15: $stmtarray = array(
                     16:     "drop table define6_tab",
                     17:     "create table define6_tab (id number)",
                     18:     "insert into define6_tab values (1)"
                     19: );
                     20: 
                     21: oci8_test_sql_execute($c, $stmtarray);
                     22: 
                     23: // Run Test
                     24: 
                     25: $sql = 
                     26: "DECLARE
                     27:   TYPE curtype IS REF CURSOR;
                     28:   cursor_var curtype;
                     29: BEGIN
                     30:   OPEN cursor_var FOR SELECT id FROM define6_tab;
                     31:   :curs := cursor_var;
                     32: END;";
                     33: 
                     34: echo "Test 1 - define last\n";
                     35: 
                     36: $s1 = oci_parse($c, $sql);
                     37: $cursor1 = oci_new_cursor($c);
                     38: oci_bind_by_name($s1, ":curs", $cursor1, -1, OCI_B_CURSOR);
                     39: oci_execute($s1);
                     40: oci_execute($cursor1);
                     41: oci_define_by_name($cursor1, 'ID', $id1);
                     42: while (oci_fetch_row($cursor1)) {
                     43:     var_dump($id1);
                     44: }
                     45: 
                     46: 
                     47: echo "Test 2 - define last with preset var\n";
                     48: 
                     49: $s2 = oci_parse($c, $sql);
                     50: $cursor2 = oci_new_cursor($c);
                     51: oci_bind_by_name($s2, ":curs", $cursor2, -1, OCI_B_CURSOR);
                     52: oci_execute($s2);
                     53: oci_execute($cursor2);
                     54: $id2 = '';
                     55: oci_define_by_name($cursor2, 'ID', $id2);
                     56: while (oci_fetch_row($cursor2)) {
                     57:     var_dump($id2);
                     58: }
                     59: 
                     60: 
                     61: echo "Test 3 - define before cursor execute\n";
                     62: 
                     63: $s3 = oci_parse($c, $sql);
                     64: $cursor3 = oci_new_cursor($c);
                     65: oci_bind_by_name($s3, ":curs", $cursor3, -1, OCI_B_CURSOR);
                     66: oci_execute($s3);
                     67: oci_define_by_name($cursor3, 'ID', $id3);
                     68: oci_execute($cursor3);
                     69: while (oci_fetch_row($cursor3)) {
                     70:     var_dump($id3);
                     71: }
                     72: 
                     73: 
                     74: echo "Test 4 - define before top level execute\n";
                     75: 
                     76: $s4 = oci_parse($c, $sql);
                     77: $cursor4 = oci_new_cursor($c);
                     78: oci_bind_by_name($s4, ":curs", $cursor4, -1, OCI_B_CURSOR);
                     79: oci_define_by_name($cursor4, 'ID', $id4);
                     80: oci_execute($s4);
                     81: oci_execute($cursor4);
                     82: while (oci_fetch_row($cursor4)) {
                     83:     var_dump($id4);
                     84: }
                     85: 
                     86: 
                     87: echo "Test 5 - define before bind\n";
                     88: 
                     89: $s5 = oci_parse($c, $sql);
                     90: $cursor5 = oci_new_cursor($c);
                     91: oci_define_by_name($cursor5, 'ID', $id5);
                     92: oci_bind_by_name($s5, ":curs", $cursor5, -1, OCI_B_CURSOR);
                     93: oci_execute($s5);
                     94: oci_execute($cursor5);
                     95: while (oci_fetch_row($cursor5)) {
                     96:     var_dump($id5);
                     97: }
                     98: 
                     99: 
                    100: echo "Test 6 - fetch on wrong handle\n";
                    101: 
                    102: $s6 = oci_parse($c, $sql);
                    103: $cursor6 = oci_new_cursor($c);
                    104: oci_define_by_name($cursor6, 'ID', $id6);
                    105: oci_bind_by_name($s6, ":curs", $cursor6, -1, OCI_B_CURSOR);
                    106: oci_execute($s6);
                    107: oci_execute($cursor6);
                    108: while (oci_fetch_row($s6)) {
                    109:     var_dump($id6);
                    110: }
                    111: 
                    112: 
                    113: // Clean up
                    114: 
                    115: $stmtarray = array(
                    116:     "drop table define6_tab"
                    117: );
                    118: 
                    119: oci8_test_sql_execute($c, $stmtarray);
                    120: 
                    121: ?>
                    122: ===DONE===
                    123: <?php exit(0); ?>
                    124: --EXPECTF--
                    125: Test 1 - define last
                    126: NULL
                    127: Test 2 - define last with preset var
                    128: string(0) ""
                    129: Test 3 - define before cursor execute
                    130: string(1) "1"
                    131: Test 4 - define before top level execute
                    132: string(1) "1"
                    133: Test 5 - define before bind
                    134: string(1) "1"
                    135: Test 6 - fetch on wrong handle
                    136: 
                    137: Warning: oci_fetch_row(): ORA-24374: %s in %sdefine6.php on line %d
                    138: ===DONE===