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

Reply via email to