Oracle debug - output a CRLF delimited block of text
v_crlf CHAR(2):=CHR(13) || CHR(10);
v_RemainingText:=v_Orig_Text || v_crlf ;
WHILE length(v_RemainingText) > 1 LOOP
v_crpos:=instr(v_RemainingText,v_crlf);
v_ThisText:=substr(v_RemainingText,1,v_crpos-1);
dbms_output.put_line(v_ThisText);
v_RemainingText:=substr( v_RemainingText
, v_crpos+2
, length(v_RemainingText)-(v_crpos+1)
);
END LOOP;
No comments:
Post a Comment