Re: Running SQL from PL/SQL

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Fri, 25 Jun 1999 16:55:49 GMT
Message-ID: <pwOc3.47801$Fz2.6224_at_news.rdc1.az.home.com>


Use the DBMS_SQL package. You can then build the SQL query in a string variable and get the results back as a cursor, then do with it what you will.

Guy Gilstrap <guyg_at_eidensys.com> wrote in message news:37739E49.3BAF0B85_at_eidensys.com...
> I have what seems like a simple problem. I want to create a PL/SQL
> procedure that accepts a file name and a Select string as parameters. I
> want the procedure to run the Select and spool the output to the text
> file. This seems simple but I cannot figure out how to call SQL from
> the PL/SQL. The only mechanism for Select seems to be SELECT INTO.
> Any suggestions would be appreciated,
> Thank you,
> Guy G
> guyg_at_eidensys.com
>
Received on Fri Jun 25 1999 - 18:55:49 CEST

Original text of this message