Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tricky Dynamic SQL question
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_at_sybrandb.demon.nl> wrote in message news:<v4sl0v05n74trk1g1urrtcfjlro3olne0s_at_4ax.com>...
> On 26 Dec 2002 03:45:07 -0800, rgaffuri_at_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
Received on Thu Dec 26 2002 - 12:48:25 CST