note 108661 added to function.oci-new-descriptor
| From: | Mike | Date: | Tue, 15 May 2012 20:46:02 +0000 |
| Subject: | note 108661 added to function.oci-new-descriptor | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-187995@lists.php.net to get a copy of this message | ||
If you're passing a clob variable to oracle stored procedure, you could:
$qry = 'begin my_sp(:largetext); end;';
$stmt = oci_parse($conn, $qry); //definition of $conn is not included here
$clob = oci_new_descriptor($conn, OCI_D_LOB);
oci_bind_by_name($stmt, ":largetext", $clob, -1, OCI_B_CLOB);
$clob->writetemporary($mylargedata);
oci_execute($stmt);
$clob->free();
oci_free_statement($stmt);
Hopefully this will help!
----
Server IP: 69.147.83.197
Probable Submitter: 70.89.94.205
----
Manual Page -- http://www.php.net/manual/en/function.oci-new-descriptor.php
Edit -- https://master.php.net/note/edit/108661
Del: integrated -- https://master.php.net/note/delete/108661/integrated
Del: useless -- https://master.php.net/note/delete/108661/useless
Del: bad code -- https://master.php.net/note/delete/108661/bad+code
Del: spam -- https://master.php.net/note/delete/108661/spam
Del: non-english -- https://master.php.net/note/delete/108661/non-english
Del: in docs -- https://master.php.net/note/delete/108661/in+docs
Del: other reasons-- https://master.php.net/note/delete/108661
Reject -- https://master.php.net/note/reject/108661
Search -- https://master.php.net/manage/user-notes.php