Re: Tricky Dynamic SQL question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 26 Dec 2002 13:45:28 +0100
Message-ID: <v4sl0v05n74trk1g1urrtcfjlro3olne0s@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 - 06:45:28 CST