note 109236 added to function.oci-bind-by-name

If you get error "ORA-22275: invalid LOB locator specified ORA-06512" when using clob try this code: <?php $connection = $db->connection; $statement = oci_parse($connection, 'begin core.clob_test(:p_varchar, :p_clob); end;'); $varchar = 'abc'; oci_bind_by_name($statement, ':p_varchar', $varchar); $lob = oci_new_descriptor($connection, OCI_D_LOB); oci_bind_by_name($statement, ':p_clob', $lob, -1, OCI_B_CLOB); // Differences between original example is method name and methods call order $lob->writeTemporary('abc abc abc abc abc'); oci_execute($statement); $lob->close(); ?> ---- Server IP: 195.54.192.44 Probable Submitter: 195.16.60.242 ---- Manual Page -- http://www.php.net/manual/en/function.oci-bind-by-name.php Edit -- https://master.php.net/note/edit/109236 Del: integrated -- https://master.php.net/note/delete/109236/integrated Del: useless -- https://master.php.net/note/delete/109236/useless Del: bad code -- https://master.php.net/note/delete/109236/bad+code Del: spam -- https://master.php.net/note/delete/109236/spam Del: non-english -- https://master.php.net/note/delete/109236/non-english Del: in docs -- https://master.php.net/note/delete/109236/in+docs Del: other reasons-- https://master.php.net/note/delete/109236 Reject -- https://master.php.net/note/reject/109236 Search -- https://master.php.net/manage/user-notes.php