Re: Dynamic procedures

Hi Robert,

Thanks for your reply.

I was thinking of using dynamic SQL to execute an anonymous PL/SQL block but I can't guarantee that the block will fit into a VARCHAR2(2000) variable which I assume must be passed to the dynamic SQL command (unless I can use a LONG somehow).

So, I was thinking that I could write the anonymous block out to file and then, from inside PL/SQL, I could invoke that anonymous block.

Do you have any ideas on how this could be done ?

Your help is much appreciated.

Natalina.

On Mon, 08 Jun 1998 21:57:06 GMT, "Robert Gauthier" <rogaut1_at_videotron.ca> wrote:

>Hi Natalina,
>
>From your requirements, you seem to need to
>use Dynamic SQL (DBMS_SQL package). This
>package allows you to write dynamic SQL and
>is available since Oracle 7.0.
>
>Hope this help !
>
>Robert Gauthier
>DBA, Application Designer
>Montréal, Canada
>
>
>
>
Received on Tue Jun 09 1998 - 08:51:25 CDT