Line Lenght limit issue with DBMS_OutPut.Put_Liine
707502Aug 11 2010 — edited Aug 11 2010I am going to ouitput about 20000 characters long string (with no line breaks) using DBMS_OUTPUT.PIUT_LINE
with in a store procedure like
Create or replace store procedure test
as
Begin
....
...
...
....
DBMS_OUTPUT.PUIT_LINE(V_QUERY);
END;
It produces error like this
"Line length limite of 255 characters exceeded........"
Intrestingly when I run the same procedure, It display the whole text without giving any error while it produces error
when the same procedure is run on the production system