Re: Call a SQL*Plus function...

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 31 Jan 1999 01:12:00 GMT
Message-ID: <36c0a487.3982638@netnews.worldnet.att.net>

On Fri, 29 Jan 1999 18:36:51 +0100, Oscar Paredes <oscar_at_fib.upc.es> wrote:

>Somebody know how to call a SQL*Plus instruction like SPOOL <file> or
>SET ....
>from a PL/SQL procedure or function??
>It is posible???

It is not possible to execute SQL*Plus commands from PL/SQL. You might be able to work around this a bit by having your PL/SQL code generate a new SQL*Plus script file. For example:

set serveroutput on
set termout off
spool c:\next_file.sql
begin
dbms_output.put_line('set echo off'); end;
/
spool off
@c:\next_file.sql

I havn't execute the exact code above, but I've done similiar things before. Hopefully this will get you started.

regards,

Jonathan Received on Sat Jan 30 1999 - 19:12:00 CST