ID: 23041 Updated by: [EMAIL PROTECTED] Reported By: don dot miguel at gmx dot ch -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.3.0 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-04-03 15:29:14] don dot miguel at gmx dot ch My Simple Test Programm is: putenv('ORACLE_SID=SEMINAR'); putenv('ORACLE_HOME=D:\oracle\ora92'); $conn = OCIPLogon('michi','michi'); $query = "begin ctx_doc.themes('idx_text','22',:result);end;"; $curs = OCIParse($conn,$query); $clob = OCINewDescriptor($conn,OCI_D_LOB); OCIBindByName($curs,":result",&$clob,-1,OCI_B_CLOB); $success = OCIExecute($curs,OCI_DEFAULT); echo $clob->load(); $clob->free(); OCIFreeStatement($curs); Which result is: Warning: OCIStmtExecute: ORA-22275: invalid LOB locator specified in c:\program files\apache group\apache\htdocs\textseminar\test.php on line 11 Warning: OCILobGetLength: OCI_INVALID_HANDLE in c:\program files\apache group\apache\htdocs\textseminar\test.php on line 12 ==> I can't acces the CLOB wich is returned by the PL/SQL procedure: ctx_doc.themes(index_name,textkey,restab)! ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23041&edit=1