Error in dbms_output.put_line()
PABFeb 16 2007 — edited Feb 16 2007Heloo ..........
I have one procedure with 4 dbms_output.put_line() statement.
DBMS_OUTPUT.PUT_LINE(SUBSTR(str,0,200));
DBMS_OUTPUT.PUT_LINE(SUBSTR(str,201,400));
DBMS_OUTPUT.PUT_LINE(SUBSTR(str,401,600));
DBMS_OUTPUT.PUT_LINE(SUBSTR(str,601,800));
Now when I excute this procedure by commenting this 4 statement procedure runs ok, BUt it give error when i uncomment this 4 statement.
I want to display sql text for dubuging........but i cant get it.
any sollution of this........I had run SET SERVEROUTPUT ON SIZE 10000.But i still get errors of "Host Bind Array too small"