You can't print more than 255 bytes in a single line.
You can write :
DBMS_OUTPUT.PUT_LINE(SUBSTR(xxx,1,255));
and if necessary
DBMS_OUTPUT.PUT_LINE(SUBSTR(xxx,256,255)); ...
anu padki <anu.padki_at_Sun.COM> a écrit dans l'article
<37126C4B.AE053197_at_Sun.COM>...
>
>
> I am trying to do
>
> dbms_output.put_line ()
>
> I get the message
>
> ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per
> line
>
> I find it in some manuals but no remedy .
>
> Thanking in advance.
>
> An
>
>
Received on Mon Apr 12 1999 - 18:28:29 CDT
