note 83091 added to function.oci-new-descriptor
| From: | ajitsingh4u at gmail dot com | Date: | Fri, 09 May 2008 13:31:40 +0000 |
| Subject: | note 83091 added to function.oci-new-descriptor | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-139217@lists.php.net to get a copy of this message | ||
<?php
// calling stored procedure to get clob data type (we use to get xml from oracle)
error_reporting(E_ALL ^ E_NOTICE);
$conn = oci_connect($user, $password);
$sql = "BEGIN sp_employee_xml_data_select(:result); END;";
$stmt = oci_parse($conn , $sql);
$objClob = oci_new_descriptor($conn, OCI_D_LOB);
oci_bind_by_name($stmt, ':result', $objClob, -1, OCI_B_CLOB);
oci_execute($stmt, OCI_DEFAULT);
$xmlData = $objClob->load($result);
$objClob->free();
oci_free_statement($stmt);
echo $xmlData;
?>
----
Server IP: 59.162.86.33
Probable Submitter: 203.193.139.178
----
Manual Page -- http://www.php.net/manual/en/function.oci-new-descriptor.php
Edit -- https://master.php.net/note/edit/83091
Del: integrated -- https://master.php.net/note/delete/83091/integrated
Del: useless -- https://master.php.net/note/delete/83091/useless
Del: bad code -- https://master.php.net/note/delete/83091/bad+code
Del: spam -- https://master.php.net/note/delete/83091/spam
Del: non-english -- https://master.php.net/note/delete/83091/non-english
Del: in docs -- https://master.php.net/note/delete/83091/in+docs
Del: other reasons-- https://master.php.net/note/delete/83091
Reject -- https://master.php.net/note/reject/83091
Search -- https://master.php.net/manage/user-notes.php