Re: Unable to Open ORACLE

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 > odin@op.net > 1.610.296.4485 -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com odin@op.net 1.610.296.4485