Oracle UTL_LMS Demos

Oracle UTL_LMS Version 11.2.0.3

General Information

Purpose

Retrieves and formats error messages in different languages

AUTHID

DEFINER

Dependencies

DBMS_SERVER_ALERT

DBMS_UNDO_ADV

UTL_LMS_LIB

First Available

10.1

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

{$ORACLE_HOME}/rdbms/admin/utllms.sql

Special Characters

Character	Description
'%s'	Substitute the next string argument
'%d'	Substitute the next integer argument
'%%'	Represents the special character %

Subprograms

FORMAT_MESSAGE

GET_MESSAGE

FORMAT_MESSAGE

Formats a retrieved error message

utl_lms.format_message(
format IN VARCHAR2 CHARACTER SET ANY_CS,
args IN UNDEFINED)
RETURN VARCHAR2 CHARACTER SET format%CHARSET;

set serveroutput on

DECLARE
s VARCHAR2(32767);
i PLS_INTEGER;
BEGIN
i := utl_lms.get_message(26052,'rdbms','ora','french', s);

dbms_output.put_line('before format, message is: ' || s);

dbms_output.put_line('formatted message is: '||
utl_lms.format_message(s, 96, 'my_string'));
END;
/

GET_MESSAGE

Retrieves an error message based on error number, product, facility, language, and message specified

utl_lms.get_message(
errnum IN PLS_INTEGER,
product IN VARCHAR2,
facility IN VARCHAR2,
language IN VARCHAR2,
message OUT NOCOPY VARCHAR2CHARCTER SET ANY_CS)
RETURN PLS_INTEGER;

set serveroutput on

DECLARE
s VARCHAR2(200);
i PLS_INTEGER;
BEGIN
i := utl_lms.get_message(601, 'rdbms', 'oci', 'German', s);
dbms_output.put_line('OCI--00601 is: ' || s);

i := utl_lms.get_message(601, 'rdbms', 'oci', 'French', s);
dbms_output.put_line('OCI--00601 is: ' || s);

i := utl_lms.get_message(601, 'rdbms', 'oci', 'Danish', s);
dbms_output.put_line('OCI--00601 is: ' || s);

i := utl_lms.get_message(601, 'rdbms', 'oci', 'Turkish', s);
dbms_output.put_line('OCI--00601 is: ' || s);

i := utl_lms.get_message(601, 'rdbms', 'oci', 'Swedish', s);
dbms_output.put_line('OCI--00601 is: ' || s);
END;
/