please help!
i am using php 4.3.1 + apache 2.0.44 + oracle 8.1i on windows xp professional sp1 with fat32
my query works fine in the sql plus console from oracle. but i get the following error when i use my query with php ->
OCIStmtExecute: ORA-03113: end-of-file on communication channel
in ...
Here is the query:
$sql = OCIParse($conn, "SELECT docid,thema,erstelltam,bereich FROM documents WHERE doctype='po' and status='undefined' and DBMS_LOB.INSTR(docdata, 'teamUeberprueft=ja',1,1)>0
ORDER BY erstelltam,docid DESC");
the same query without the DBMS_LOB-function works fine with php, too.
A new installation of all components (windows,php,apache,oracle)did not solve my problem. also with other php distributions i get the error. i have set the environments in windows and in the php.ini (oracle_home=c:\oracle\ora81, sid=mail).
