Search notes:

Oracle: UTL_LMS

utl_lms retrieves and formats messages.

get_message

set serveroutput on

declare
   msg varchar2(256);
   rc  pls_integer;
begin
   rc := utl_lms.get_message(2273, 'rdbms', 'ora', 'german', msg);
   dbms_output.put_line('rc  = ' || rc);
   dbms_output.put_line('msg = ' || msg);
end;
/
--
-- rc  = 0
-- msg = Einige Fremdschlüssel beziehen sich auf diesen Primär-/eindeutigen Schlüssel
Compare with sqlerrm.
See also Error messages.

format_message

Note the ellipis (...) in the definition of the function format_message:
function format_message(
   format in varchar2 character set any_cs,
   args ...
)

See also

Oracle UTL packages

Index