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]

Reply via email to