Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

ORA_GRANTEE returns the number of elements in the list indexed by a PLS_INTEGER datatype

SQL> 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> SQL>