UTL_FILE writes text/script files into server directory. We want the same to happen in client directory. Spooling is one way. Using DBMS_OUTPUT.PUT_LINE, I managed to split the argument string into 255 chars and display on a number of lines. But I want in a single line. DBMS_OUTPUT.PUT followed by DBMS_OUTPUT.NEW_LINE could be one soltion. But I get error in SCOTT schema with dopl as procedure name:
BEGIN dopl; END;
ERROR at line 1:
ORA-20000: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 99
ORA-06512: at "SCOTT.DOPL", line 12
ORA-06512: at line 1
How can I manage to display let us say 500 characters in a single line in SQL*Plus using SQL and PL/SQL. Can any of the other built in or custom packages help.