utl_lms
retrieves and formats messages. 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
sqlerrm
. ...
) in the definition of the function format_message
: function format_message( format in varchar2 character set any_cs, args ... )