Hi
Is there any why to display the message more then 180 length Using Dbms_output.
Like i have one message it is length is 180 but if i use dbms_output.put_line('xxxx'), its comming in next line, i want every thing in one line.
Thanks
ABC
Printable View
Hi
Is there any why to display the message more then 180 length Using Dbms_output.
Like i have one message it is length is 180 but if i use dbms_output.put_line('xxxx'), its comming in next line, i want every thing in one line.
Thanks
ABC
set linesize 222
Hi marist89
Thanks for your reply, but i am Using dbms_output in package, so i cannot use set function in Pacakges.
Thanks
ABC
set line is not a function geez
Put this in your procedure
DBMS_OUTPUT.ENABLE(1000000);
This sets the buffer for DBMS_OUTPOUT to 1MB.
The line size for DBMS_OUTPUT should be 1022 bytes.