--递归打印LONG VALUE
procedure pDsp(str varchar2) is
begin
if length(str) > 80 then
dbms_output.put_line(substr(str, 1, 80));
pDsp(substr(str, 81));
else
dbms_output.put_line(str);
end if;
exception
when others then
dbms_output.enable(1000000);
pDsp(str);
end pDsp;