Re: Unable to Open ORACLE

Hello, John Kolvereid wrote: > > Hi, > Me again, My table has a CLOB in it. When I tried the same querry w/ > another table w/o a CLOB it succeeded. Are CLOBs an issue? Please > advise. Thanks. I have no idea what is the problem here, but you may want to try Metabase which is a PHP database abstraction that handles CLOB/BLOBs very well with any supported database including Oracle. Take a look at the example described in Metabase tutorial document. http://phpclasses.UpperDesign.com/browse.html/20 Regards, Manuel Lemos > > 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