Re: TEXT_IO Package

Another problem with DBMS_OUTPUT is that you don't see the output until after the PL/SQL ends; what happens if you have a loop during a long running procedure - you'll never know it.

Does your temp table preserve any msgs if the proc dies or has to be killed?

The problem with TEXT_IO is that it is only available in Developer, but that is better than nothing. I have used this to write a client side file that I can edit while the proc runs, so that I can see the progress.

"Mark Malakanov" <markmal_at_home.com> wrote in message news:0V2z6.27824$XV.7161690_at_news3.rdc1.on.home.com...
> DBMS_OUTPUT has limit 10Kb. Sometimes it is not enough.
> Also it trims leading ' ' spaces.
> What I use:
>
> create global temporary table outtmp(n number, s varchar2(4000)) on commit
> preserve rows;
>
> create procedure out(i in number, s in varchar2) as
> begin
> insert into outtmp values (i,s);
> end;
> /
>
> I use proc OUT in PL/SQL. After this I select s from outtmp order by n.
>
> --
> -----------------------------------------------------
> Thanks,
> Mark
>
> "Michal" <michalp_at_cr-media.com.pl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
> news:3ac977f0$1_at_news.vogel.pl...
> > How can I get the text_io package. Probably I have to run some kind of a
> > script but I don't know which one. Can anybody help me?
> > (I'm looking fro the text_io because sometimes DBMS_OUTPUT.PUT_LINE
 doesn't
> > display what I want, even when the serveroutput in on)
> >
> > Thanks in advance
> >
> >
> > --
> > Michal
> >
> >
>
>
Received on Thu Apr 05 2001 - 21:32:50 CEST