how to print more than 500 characters on DBMS output
598066Sep 14 2007 — edited Sep 14 2007Hi,
I am trying to print more than 500 characters on the DBMS_OUTPUT. But why is this below program printing only 100 characters.
Should I make any changes to the settings?
Please help
Thanks
Program:
*********************************
set serveroutput on
Declare
S Long := 'X';
Begin
for i in 1..100
Loop
S := S || i;
End loop;
dbms_output.put_line(s);
End;
/
******************************************