note 1564 deleted from Oracle 8 functions by ronabop
| From: | ronabop@php.net | Date: | Sun, 01 Oct 2000 05:35:36 +0000 |
| Subject: | note 1564 deleted from Oracle 8 functions by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-5725@lists.php.net to get a copy of this message | ||
Use option: OCI_DEFAULT for Execute command:
OCIExecute($stmt, OCI_DEFAULT);
for retrieve data use (after fetch):
$result = OCIResult($stmt, $n);
if (is_object ($result)) $result = $result->load();
For INSERT or UPDATE statetment use:
$sql = "insert into table (field1, field2) values (field1 = 'value', field2 =
empty_clob()) returning field2 into :field2";
OCIParse($conn, $sql);
$clob = OCINewDescriptor($conn, OCI_D_LOB);
OCIBindByName ($stmt, ":field2", &$clob, -1, OCI_B_CLOB);
OCIExecute($stmt, OCI_DEFAULT);
$clob->save ("some text");