How to print Text for more than 255 characters.
413240Sep 25 2006 — edited Sep 26 2006Actually I am writing dynamic sql in which some text is assigned to some variables
and then contacating tohse variables to create one complete SQL. So the text into that variable is more than 25 chars, which i want to print to check wether the sql generated is correct. While doing do I am getting following error.
ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 133
As i understood that in one line of DBMS_OUTPUT.PUT_LINE can accomodate only 255 characters. What is the alternative to get the text printed.??
Sample code -->>
SET SERVEROUTPUT ON
DECLARE
T varchar2(1000);
T1 varchar2(100);
T2 varchar2(300);
T3 varchar2(250);
T4 varchar2(85);
BEGIN
-- Assigning values to T1,T2,T3,T4...
T := T1 || T1 || T3 || T4;
DBMS_OUTPUT.PUT_LINE(T);
END;