I was playing around with Exception handling (11.1.0.7) and found a 510 character limit for SQLERRM. I started googling the topic, and I found a couple of sites indicating the length was larger, but our agency's internet blocking software wouldn't let me get to it.
declare
l_err varchar2(2000) := '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890';
begin
raise_application_error(-20500, l_err );
exception
when others then
dbms_output.put_line(length(l_err));
dbms_output.put_line(length(SQLERRM));
end;
600
510
Just so that I don't stop looking too early ... any way around the 510 character limit?
--=Chuck