Exclude ORA-06512 from error message
finecFeb 21 2013 — edited Feb 21 2013Hi all,
Lets have a simple example:
declare
EXP_FRZN_VER EXCEPTION;
begin
if (1=1) then
raise EXP_FRZN_VER;
end if;
exception
when EXP_FRZN_VER then
raise_application_error (-20303, 'Frozen version cannot be modified!');
when OTHERS then
dbms_output.put_line('TEST');
end;
I want to send error message to my web application through raise_application_error.
Error message looks like:
Error report:
ORA-20303: Frozen version cannot be modified!
ORA-06512: at line 12
Question: Is there a way to exclude string "ORA-06512: at line 12" from that message? I need to handle it on DB side...
Thanks
Finec