dbms_output available length extender [ 853 views ]
Goal: to extend the character limited dbms_output
CREATE OR REPLACE PROCEDURE dbms_output_ex (p_mess VARCHAR2) IS counter PLS_INTEGER := 1; your_output_variable VARCHAR2(32767) := p_mess; BEGIN WHILE counter < LENGTH(your_output_variable) LOOP DBMS_OUTPUT.PUT_LINE(SUBSTR(your_output_variable,counter,255)); counter := counter + 255; END LOOP; END;
If the output is too short for you use
dbms_output_ex(something)
instead of dbms_output.put_line(something)