Re: PL/SQL IO

1 this is impossible. You'll need to dump it to a file or use SPOOL before you start your pl/sql procedure

2 There isn't. By default anything SPOOLed will end up on the client. In Developer 2000 there is the text_io package for files on the client, while developer pl/sql is
running on the client.

Hth,

Sybrand Bakker, Oracle DBA

"anonymous" <xx_at_yy.zz> wrote in message
news:h_o75.2461$cu1.6838_at_news1.rdc1.ct.home.com...
> 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 Sun Jul 02 2000 - 00:00:00 CDT