Return to bug46994.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Bug #46994 (CLOB size does not update when using CLOB IN OUT param in stored procedure)
                      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:        "create or replace procedure bug46994_proc1(p1 in out nocopy clob) is
                     17:                 begin
                     18:                         dbms_lob.trim(p1, 0);
                     19:                         dbms_lob.writeappend(p1, 26, 'This should be the output.');
                     20:          end bug46994_proc1;",
                     21:        "create or replace procedure bug46994_proc2(p1 in out nocopy clob) is
                     22:                 begin
                     23:                         dbms_lob.trim(p1, 0);
                     24:                         dbms_lob.writeappend(p1, 37, 'The output should be even longer now.');
                     25:          end bug46994_proc2;"
                     26: );
                     27: 
                     28: oci8_test_sql_execute($c, $stmtarray);
                     29: 
                     30: // Run Test
                     31: 
                     32: $myclob = oci_new_descriptor($c, OCI_D_LOB);
                     33: $myclob->writeTemporary("some data", OCI_TEMP_CLOB);
                     34: 
                     35: echo "Test 1\n";
                     36: 
                     37: $s = oci_parse($c, "begin bug46994_proc1(:myclob); end;");
                     38: oci_bind_by_name($s, ":myclob", $myclob, -1, SQLT_CLOB);
                     39: oci_execute($s, OCI_DEFAULT);
                     40: var_dump($myclob->load());
                     41: 
                     42: echo "Test 2\n";
                     43: 
                     44: $s = oci_parse($c, "begin bug46994_proc2(:myclob); end;");
                     45: oci_bind_by_name($s, ":myclob", $myclob, -1, SQLT_CLOB);
                     46: oci_execute($s, OCI_DEFAULT);
                     47: var_dump($myclob->load());
                     48: 
                     49: echo "Test 3\n";
                     50: 
                     51: $s = oci_parse($c, "begin bug46994_proc1(:myclob); end;");
                     52: oci_bind_by_name($s, ":myclob", $myclob, -1, SQLT_CLOB);
                     53: oci_execute($s, OCI_DEFAULT);
                     54: var_dump($myclob->load());
                     55: 
                     56: echo "Test 4\n";
                     57: 
                     58: var_dump($myclob->load());  // Use cached size code path
                     59: 
                     60: // Cleanup
                     61: 
                     62: $stmtarray = array(
                     63:        "drop procedure bug46994_proc1",
                     64:        "drop procedure bug46994_proc2"
                     65: );
                     66: 
                     67: oci8_test_sql_execute($c, $stmtarray);
                     68: 
                     69: oci_close($c);
                     70: 
                     71: ?>
                     72: ===DONE===
                     73: <?php exit(0); ?>
                     74: --EXPECTF--
                     75: Test 1
                     76: string(26) "This should be the output."
                     77: Test 2
                     78: string(37) "The output should be even longer now."
                     79: Test 3
                     80: string(26) "This should be the output."
                     81: Test 4
                     82: string(26) "This should be the output."
                     83: ===DONE===