note 41705 added to ref.oci8
| From: | cyrill at _malevanov_dot_spb_dot_ru dot php dot net | Date: | Tue, 20 Apr 2004 15:42:05 +0000 |
| Subject: | note 41705 added to ref.oci8 | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-68370@lists.php.net to get a copy of this message | ||
How to pass CLOB as a stored procedure parameter:
<?
error_reporting(1+2+4+8);
$conn = OCILogon('batdtd', 'batdtd', 'bathome');
$lob = OCINewDescriptor($conn, OCI_D_LOB);
$stmt = OCIParse($conn, "declare rs varchar2(32767); begin :rs := aaa(:par); end;");
$lob_data = 'abcdefgh';
echo "binding lob...";
OCIBindByName($stmt, ':par', &$lob, -1, OCI_B_CLOB);
echo "done<br>binding rs...";
$rs = '';
OCIBindByName($stmt, ':rs', &$rs, 32767);
echo "done<br>writing temp lob...";
$lob -> WriteTemporary($lob_data);
echo "done<br>executing...";
OCIExecute($stmt, OCI_DEFAULT);
echo "done<br>rs = '$rs'";
OCICommit($conn);
$lob -> free();
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
----
Manual Page -- http://www.php.net/manual/en/ref.oci8.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+41705
Delete -- http://master.php.net/manage/user-notes.php?action=delete+41705&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+41705&report=yes
Search -- http://master.php.net/manage/user-notes.php