#23041 [Fbk->NoF]: OCINewDescriptor()

ID: 23041 Updated by: sniper@php.net Reported By: don dot miguel at gmx dot ch -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.3.0 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-04-03 19:45:31] sniper@php.net 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