Re: TEXT_IO Package

I have a Java routine that you can load into Oracle to provide Access to OS commands like Shell scripts. I currently use this in a Unix environment and it works great.

Mark Malakanov wrote:

> 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 - 20:45:13 CEST