Oracle DBMS_RULE_EXP_RL_INTERNAL
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
ANYDATA DBMS_RULE_EXP_UTL PLITBLM
DBA_RULES DBMS_SYS_ERROR RE$NAME_ARRAY
DBA_TABLES DBMS_ZHELP RE$NV_LIST
DBMS_ASSERT EXPDEPOBJ$ RULE$
DBMS_LOB NOEXP$ RULE_SET_IEUAC$
DBMS_RULES_LIB OBJ$ USER$
DBMS_RULE_EXP_RULES    
Documented No
First Available Not Known
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvtreut.plb
Subprograms
 
I_CREATE_EXP
Undocumented dbms_rule_exp_rl_internal.i_create_exp(
OBJID     IN  NUMBER,
NEW_BLOCK OUT BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
I_GRANT_EXP
Undocumented dbms_rule_exp_rl_internal.i_grant_exp(
OBJID     IN  NUMBER,
ISDBA     IN  BINARY_INTEGER,
GRANTOR   OUT VARCHAR2,
NEW_BLOCK OUT BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
I_GRANT_SYSPRIVS_EXP
Undocumented dbms_rule_exp_rl_internal.i_grant_sysprivs_exp(NEW_BLOCK OUT BINARY_INTEGER)
RETURN VARCHAR2;
DECLARE
 outVal BINARY_INTEGER;
 retVal dbms_id;
BEGIN
  retVal := dbms_rule_exp_rl_internal.i_grant_sysprivs_exp(outVal);
  dbms_output.put_line('Out: ' || TO_CHAR(outVal));
  dbms_output.put_line(retVal);
END;
/
Out:
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

PL/SQL procedure successfully completed.
 
I_INSTANCE_CALLOUT
Undocumented dbms_rule_exp_rl_internal.i_instance_callout(
NAME    IN VARCHAR2
SCHEMA  IN VARCHAR2
PREPOST IN BINARY_INTEGER);
exec dbms_rule_exp_rl_internal.i_instance_callout('TEST', 'UWCLASS', 1);

PL/SQL procedure successfully completed.
 
I_SCHEMA_CALLOUT
Undocumented dbms_rule_exp_rl_internal.i_schema_callout(
SCHEMA  IN VARCHAR2,
PREPOST IN BINARY_INTEGER);
exec dbms_rule_exp_rl_internal.i_schema_callout('UWCLASS', 1);

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_RULE
DBMS_RULE_ADM
DBMS_RULE_EXPIMP
DBMS_RULE_EXP_EC_INTERNAL
DBMS_RULE_EXP_EV_CTXS
DBMS_RULE_EXP_RS_INTERNAL
DBMS_RULE_EXP_RULE_SETS
DBMS_RULE_EXP_UTL
DBMS_RULE_EXP_UTLI
DBMS_RULE_IMP_OBJ
DBMS_RULE_INTERNAL
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved