Hi, Me again, My table has a CLOB in it. Could that be a problem. When I tried the same querry on another table w/o a CLOB it succeeded. Please advise. Thanks.
John Kolvereid wrote: > 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 > [EMAIL PROTECTED] > 1.610.296.4485 -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]