Mega Code Archive
ORA_GRANTEE returns the number of elements in the list indexed by a PLS_INTEGER datatype
SQL>
SQL> DECLARE
2 user_list DBMS_STANDARD.ORA_NAME_LIST_T;
3 counter PLS_INTEGER;
4 BEGIN
5 IF ora_sysevent = 'GRANT' THEN
6 counter := ora_grantee(user_list);
7 dbms_output.put_line('counter:'||counter);
8
9 END IF;
10 END;
11 /
PL/SQL procedure successfully completed.
SQL>