Re: PL/SQL Output problem

Mark Gumbs wrote:
>
> Hi,
>
> When trying to output a long record using put_line and put to a file, i
> get a 'Write Error' message.
> I assume it is because the record length is longer than 1023 bytes and
> my record length is about 9000 bytes long.
> Is there a sneaky cheat to get around this problem?
>
> Any replies to mgumbs_at_hotmail.com or mgumbs_at_vossnet.co.uk (preferably
> both!)
>
> Mark.

Add this to the top of the script or to your login.sql file:

set serveroutput on size 1000000

Cheers.
Jeff

-- 
Senior Software Engineer
Fairway Systems, Inc.
jcann_at_fairway.com