Re: TEXT_IO Package

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

>

>