Re: OCI describe parameters
Date: Wed, 4 Dec 2002 22:51:59 +0000 (UTC)
Message-ID: <asm0ue$pu2$1_at_venus.btinternet.com>
You could do a select from all_tab_columns where table_name = 'moose' and process these results prior to your insert statement.
Adrian
"Paul Dembry" <pade_at_nospam.trifox.com> wrote in message
news:aslg8i$l03_at_dispatch.concentric.net...
> I want to describe the input parameters for the following:
>
> insert into moose values(?,?)
> or
> insert into moose(id,value) values(?,?)
>
> I want a method to know what the underlying moose columns' datatypes are.
> Why? Because LONG/LONG RAW must be handled differently from CLOB/BLOB and
> the incoming statements are dynamic. I have looked through the OCI 8
> documents but nothing looks appropriate. Does anyone know if this can be
> done?
> TIA,
> Paul
>
>
Received on Wed Dec 04 2002 - 23:51:59 CET