i got this error when i used dbms_output.put_line and passed a string of more than 255 characters. in order to get rid of this error, following could be used
PROCEDURE print_ln (p_msg VARCHAR2) IS l_loops NUMBER; BEGIN l_loops := FLOOR(LENGTH(p_msg)/250); IF MOD (LENGTH(p_msg),250) > 0 THEN l_loops := l_loops + 1; END IF; FOR i in 1..l_loops LOOP DBMS_OUTPUT.PUT_LINE(substr(p_msg,(i-1)*250+1,250)); END LOOP; END;
No comments:
Post a Comment