Re: SQL* Plus from within PL/SQL block

In article <8s2iok$t7n$1_at_nnrp1.deja.com>,   cplatts_at_my-deja.com wrote:
> I want to call sql*plus and run a .sql file that produces a sql*plus
> report. I need to use pl/sql, since I only want to produce the report
> if a certain condition exists. If there is a better way to produce a
> report based on conditions within an Oracle table, I certainly would
> pursue it.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

As far as I know (apart from Pro*C and OCI) PL/SQL is the way to script when you need information based upon certain conditions being met in the database.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.