Dynamic procedures

From: a <a_at_b.c>
Date: Mon, 8 Jun 1998 23:21:18 +0800
Message-ID: <6lgvlp$bv9$1@news.iinet.net.au>

Hi,

I need to create dynamic code that will use cursor manipulation and write to a text file.

My approach was to output a PL/SQL anonymous block to a file that could be later invoked from SQL*Plus, etc or to directly write an SQL*Plus script.

Given that I will be writing this code from within PL/SQL, is it possible to execute an SQL*Plus script directly from within PL/SQL ? Someone suggested that I may be able to use DBMS_PIPE to invoke the SQL*Plus script in another session but I'm hoping that there may be an easier way.

Can anyone help me out ?

Thanks,

Natalina. Received on Mon Jun 08 1998 - 10:21:18 CDT