ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Internal support for Management Packs and Real Application Testing (RAT)
AUTHID
DEFINER
Dependencies
DBMS_ADVISOR
DBMS_RAT_MASK_INTERNAL
PRVTEMX_ADMIN
DBMS_ASH_INTERNAL
DBMS_SQLPA
PRVTEMX_CELL
DBMS_KEG_LIB
DBMS_SQLTUNE
PRVT_ADVISOR
DBMS_MANAGEMENT_PACKS
DBMS_SYS_ERROR
PRVT_AWR_VIEWER
DBMS_PERF
DBMS_WRR_PROTECTED
PRVT_HDM
Documented
No
Exceptions
Error Code
Reason
ORA-13722
invalid input value
for procedure argument PACK_NAME
Completes successfully if the named pack is enabled
prvt_smgutil.check_pack_enabled(pack_name IN VARCHAR2);
exec prvt_smgutil.check_pack_enabled('RAT');
BEGIN prvt_smgutil.check_pack_enabled('RAT'); END;
*
ERROR at line 1:
ORA-13722: invalid input value for procedure argument PACK_NAME
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_SMGUTIL", line 41
ORA-06512: at line 1
Completes successfully if the named pack is enabled
prvt_smgutil.is_pack_enabled(pack_name IN VARCHAR2) RETURN BOOLEAN;
BEGIN
IF prvt_smgutil.is_pack_enabled('DIAGNOSTIC') THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line('Disabled');
END IF;
END;
/ Enabled
prvt_smgutil.validate_arg_len(
p_value IN VARCHAR2,
p_name IN VARCHAR2,
p_len IN NUMBER);
exec prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 1);
BEGIN prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 1); END;
*
ERROR at line 1:
ORA-13723: input value for procedure argument MORGAN exceeds maximum allowed length of 1
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.PRVT_SMGUTIL", line 137
ORA-06512: at line 1
-- note that the following is also a violation of ORA-13723
-- likely an invalid exception message as a P_LEN of 3 also fails