Re: How to output to screen or a file in client's machine via PL/SQL

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 30 Dec 2004 01:30:15 GMT
Message-ID: <HSIAd.4589$yV1.3902@newssvr14.news.prodigy.com>

my888_at_telstra.com wrote:

> Dear all,
> I tried to do output from pl/sql to a client's box, I tried using
> dbms_output and it has a hard limit 1 Megabyte. I tried UTL_FILE
> package, but it can only output to a Server's directory. How can I run
> an PL/SQl and output to screen or a file in client's machine?? Thanks
> for your help!!

>
: AskTom has a topic "how to get around Dbms_output limitations":

 >
>> Mark,
>> I knew that solution, however, the output is getting from an SQL rather
>> from pl/sql.  How do I do it inside PL/SQL???  Thank you!
>> 
>> 888
>>

I'd have to see an example of exactly what you are trying to do, including version info, and where it is failing, to potentially be of any further use.

-Mark Bole Received on Wed Dec 29 2004 - 19:30:15 CST