2 Bug #44008 (Incorrect usage of OCI-Lob->close crashes PHP)
5 $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
6 require(dirname(__FILE__).'/skipif.inc');
11 require dirname(__FILE__).'/connect.inc';
16 "create or replace procedure bug44008_proc (p in out clob)
21 oci8_test_sql_execute($c, $stmtarray);
25 $s = oci_parse($c, 'begin bug44008_proc(:data); end;');
26 $textLob = oci_new_descriptor($c, OCI_D_LOB);
27 oci_bind_by_name($s, ":data", $textLob, -1, OCI_B_CLOB);
28 oci_execute($s, OCI_DEFAULT);
29 $r = $textLob->load();
32 // Incorrectly closing the lob doesn't cause a crash.
33 // OCI-LOB->close() is documented for use only with OCI-Lob->writeTemporary()
39 "drop procedure bug44008_proc"
42 oci8_test_sql_execute($c, $stmtarray);