John: Yes, CLOBs are a little more difficult to access. The best way I've used them is to use the DBMS_LOB package in Oracle. Here's a link on technet.oracle.com to some documentation.
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev. 817/a76940/adl03pr4.htm#146661 I suggest using this with stored procedures and bind variables. php.net has more info on using stored procedures bind variables. Good luck, Anthony Carlos > From: John Kolvereid <[EMAIL PROTECTED]> > Date: Mon, 03 Dec 2001 22:17:44 -0800 > To: [EMAIL PROTECTED], John Kolvereid <[EMAIL PROTECTED]> > Subject: [PHP-DB] Re: Unable to Open ORACLE > > 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. > > 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]
