Re: PL/SQL output problem

Hi,

If you still have that problem...
there are two solutions:

1. upgrade to Oracle 8i, there you can set the recordlength to 32k
2. is not sneaky and no cheat ... just hard work: slice your output into pieces < 1023 Byte and glue it together afterwards with a little C-utility (that's what we did before 8i)

cheers
Gerald

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.
Received on Wed Sep 15 1999 - 10:57:33 CDT