Re: Re: Unable to Open ORACLE

On Mon, Dec 03, 2001 at 10:16:13PM -0800, John Kolvereid wrote: > 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. CLOBS were indroduced in oracle8 you need to use the oci*() functions to get them from the database. the ora*() functions do not (and will never) support this datatype as it's technically not possible. your problem will "vanish" once you use the oci*() functions. tc > > 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >