Hi All!
First. I don't speak fluent English. Sorry.
A have to load two CLOB datas from a PL/SQL procedure.
/PROCEDURE PROBAPROC (
xmlid IN NUMBER,
xmldata1 OUT CLOB,
xmldata2 OUT CLOB
)/
And any of Clob's may be empty.
In php, i try to load the clobs like:
<?php
$query = "begin probaproc(1, :clob1, :clob2); end;";
$stmnt = OCIParse($conn, $query);
$clob1 = OCINewDescriptor($conn, OCI_D_LO😎;
$clob2 = OCINewDescriptor($conn, OCI_D_LO😎;
OCIBindByName($stmnt, ':clob1', &$clob1, -1, OCI_B_CLO😎;
OCIBindByName($stmnt, ':clob2', &$clob2, -1, OCI_B_CLO😎;
OCIExecute($stmnt, OCI_DEAFULT);
xmldata1 = $clob1->load();
xmldata2 = $clob2->load();
?>
if the clobs are empty, i get a warning:
OCILobGetLength: OCI_INVALID_HANDLE
Can anybody help me?
Thanks.
almi