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.
Advertising
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]
