<
>

dbms_output available length extender  [ 741 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)

Tuesday, June 3rd, 2014 at 18:32.
Filed under oracle.

#sidebar a { color:#fff; } #sidebar ul ul li { color: #DEF585; } #sidebar h2 { color: #fff; } #sidebar ul p, #sidebar ul select { color: #BEDDBE; } #backfly { background: url(images/golfBallWallPaper.jpg) left bottom fixed repeat-x #65a51d; }