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 > > [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] > -- 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]