#24278 [Fbk->NoF]: error while trying to save LOB
ID: 24278
Updated by: sniper@php.net
Reported By: trent at low dot ru
-Status: Feedback
+Status: No Feedback
Bug Type: OCI8 related
Operating System: Linux, Win32
PHP Version: 4CVS-2003-08-15 (stable)
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2003-10-18 17:15:40] lsmith@php.net
Have you tried using the sample code provided in the php manual?
http://www.php.net/manual/en/function.ocinewdescriptor.php
------------------------------------------------------------------------
[2003-06-21 10:28:43] trent at low dot ru
Description:
------------
I got these errors while trying to inputing string to LOB using LOB's
method save(); :
Warning: save() [function.save.html]: OCILobWrite: OCI_INVALID_HANDLE
in /www/sample.php on line 15
Warning: load() [function.load.html]: OCILobGetLength:
OCI_INVALID_HANDLE in /www/sample.php on line 19
This was tested with:
4.3.1-win32
4.3.1-linux
Latest snapshot on Linux.
Note: in oracle function there is in/out parameter used.
Additional exception from Oracle: ORA-22275: invalid LOB locator
specified.
Reproduce code:
---------------
//logging in
$conn = OCILogon('user', 'pass', 'srvname');
//creating new LOB locator
$clob = OCINewDescriptor($conn, OCI_D_LOB);
$sql = 'begin :ret:=test(lob_object=>:lob_object_param); end;';
//parsing query - ok
$stmt = OCIParse($conn, $sql);
//binding variables - ok
OCIBindByName($stmt, ':lob_object_param', &$clob, -1, OCI_B_CLOB);
OCIDefineByName($stmt, ':lob_object_param', $clob, OCI_B_CLOB);
OCIBindByName($stmt, ':ret', $return, 4);
OCIExecute($stmt, OCI_DEFAULT);
if($clob->save($param)) { // Warning: OCILobWrite: OCI_INVALID_HANDLE
in sample.php on line 15
OCICommit($conn); // this warning appears only when using method
save(); of LOB locator
}
print $clob->load(); // Warning: OCILobGetLength: OCI_INVALID_HANDLE
in sample.php on line 19
// when using load method in LOB locator
$clob->free();
OCIFreeStatement($stmt);
Expected result:
----------------
I'm trying to save string as CLOB using Oracle function.
I do expect it to work fine =)
Maybe I'm doing something extremely wrong?
If so, please, correct me.
Thanx in advance.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24278&edit=1
Thread (6 messages)