Oracle | UTL

Oracle UTL_LMS Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Retrieves and formats error messages in different languages

AUTHID DEFINER

Dependencies

DBMS_GSM_DBADMIN	DBMS_UNDO_ADV	ORA12C_STRONG_VERIFY_FUNCTION
DBMS_GSM_POOLADMIN	DBMS_WRR_REPORT	ORA12C_VERIFY_FUNCTION
DBMS_MACUTL	KUPM$MCP	ORA_COMPLEXITY_CHECK
DBMS_REPORT	ORA12C_STIG_VERIFY_FUNCTION	UTL_LMS_LIB
DBMS_SERVER_ALERT

Documented Yes

First Available 10.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC and DVSYS

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 ...) 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', 'English', s);

        dbms_output.put_line('English: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Spanish', s);

        dbms_output.put_line('Spanish: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Italian', s);

        dbms_output.put_line('Italian: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Dutch', s);

        dbms_output.put_line('Dutch: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'French', s);

        dbms_output.put_line('French: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'German', s);

        dbms_output.put_line('German: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Danish', s);

        dbms_output.put_line('Danish: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Norwegian', s);

        dbms_output.put_line('Norwegian: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Polish', s);

        dbms_output.put_line('Polish: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Swedish', s);

        dbms_output.put_line('Swedish: OCI--00601 is: ' || s);

      

        i := utl_lms.get_message(601, 'rdbms', 'oci', 'Turkish', s);

        dbms_output.put_line('Turkish: OCI--00601 is: ' || s);

      END;

      /