|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits              [2003-10-18 17:15 UTC] lsmith@php.net
  [2003-10-28 04:48 UTC] sniper@php.net
  [2003-11-26 08:40 UTC] tony2001 at phpclub dot net
 | |||||||||||||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 05:00:02 2025 UTC | 
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.