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
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;
/