PROCEDURE: SYS.REVOKE_PRIV

Source

1 procedure revoke_priv as
2   priv_not_granted EXCEPTION;
3   PRAGMA EXCEPTION_INIT(priv_not_granted, -1952);
4 begin
5   execute immediate 'revoke execute on sys.dbms_sys_sql from xdb';
6 exception
7   when priv_not_granted then
8     NULL;
9 end;