Unable to Open ORACLE

From: Date: Tue, 04 Dec 2001 05:54:48 +0000
Subject: Unable to Open ORACLE
Groups: php.db 
Request: Send a blank email to php-db+get-14791@lists.php.net to get a copy of this message
Hi, I tried the following snippet from http://www.php.net/manual/en/ref.oracle.php $query = "Select * from patients where clientid = 'DEMO'"; ora_parse($curs, $query); ora_exec($curs); ora_fetch($curs); The parse executed successfully, but the exec complained that Ora_Exec failed (ORA-00932: inconsistent datatypes -- while processing OCI function OEXEC/OEXN) Earlier I had taken an example from Thies Arntzen's conf notes and successfully opened, parsed and fetehed, using the same query and the same db, only w/ OCI commands. Is there a problem w/ the ordinary Oracle functions, possibly w/ a mismatch between them and the undelying OCI codes? Please advise. Thank you. -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com odin@op.net 1.610.296.4485

« previous php.db (#14791) next »