How to show only error message oracle raise application error

Question

I am writing oracle triggers and i have some error messages.

I use this code for handling error:

raise_application_error(-20001, 'error message, please do not this');

But this shows very lot info; For example:

ora-20001: <<custom message>>. 
ora-06512: at <<package.procedure_name>>, line 100

I want only show error message body: "error message, please do not this"

Is there a way to do this?

Answer 1

Since I found this question pretty high in my Google search, here is a simple method to just get the error message:

declare
  procedure test is
  begin
    raise_application_error(-20222, 'This is an error');
  end test;
begin
  test;
exception
  when others then
    dbms_output.put_line(replace(sqlerrm, 'ORA' || sqlcode || ': ', ''));
end;

Will output:

This is an error