I think I can do this with DBMS_SQL, Id really rather avoid using C.
Id have to get that approved.

I thought I read on asktom, that pl/sql automatically takes pl/sql
variables and makes them bind variables so I really dont have to use
the 'using' command?

Sybrand Bakker <gooiditweg@sybrandb.demon.nl> wrote in message news:<v4sl0v05n74trk1g1urrtcfjlro3olne0s@4ax.com>. ..
> On 26 Dec 2002 03:45:07 -0800, rgaffuri@cox.net (Ryan Gaffuri) wrote:
>
> >I think I can do this with dbms_sql and dynamically create columns
> >with define_columns. Not sure how. Has anyone done this?
>
>
> The only thing that would probably help you is using pro*c, dynamic
> sql method 4 (from the top of my head), where you can call pro*c to
> describe a table and set up bind lists.
> Never done this myself though.
> Anyway the code snippet you provided should read execute immediate
> .... using, or your code will be completely unscalable.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address