Re: PL/SQL IO

You might be able to use the dbms_output package if the following example is similar to what you are trying to accomplish:

SQL> create or replace procedure myproc is   2 begin
  3 dbms_output.put_line('hello');
  4 end;
  5 /
SQL> set serveroutput on size 10000
SQL> exec myproc
hello
SQL> You can use the spool sqlplus command to send this output to a file on the client side.

Frank Hubeny

anonymous wrote:

> 1) How do I put data in the SQL/PLUS buffer (the sql/plus command buffer)
> from a PL/SQL procedure when I run it in SQL/PLUS using
> exec myproc()
>
> command?
>
> 2)There is any package for IO on the client side. The utl_file package works
> only on the server side
>
> Thanks,
>
> Rafael.
Received on Mon Jul 03 2000 - 00:00:00 CDT