ID: 23041 Comment by: nirfri at hotmail dot com Reported By: don dot miguel at gmx dot ch Status: No Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.3.0 New Comment:
I have the same problem. seems like php and oracle clobs, through procedures don't interact good. :p Nir Previous Comments: ------------------------------------------------------------------------ [2003-04-09 06:37:41] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [2003-04-03 19:45:31] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [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
