Unable to Open ORACLE
| From: | John Kolvereid | 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