The SET_DBA_ROLE stored procedure is used to set the DBA role for the current session if the invoker has DBA privileges already granted to them.
Exceptions
- NOT_DBA – Exception for ORA 1924 error.
- OTHERS
Example
SET SERVEROUTPUT ON; EXEC IN_DB_UTIL.SET_DBA_ROLE;