2:
3: procedure disable is
4: not_granted exception;
5: pragma exception_init(not_granted, -1927);
6: type grant_collection is table of sys.dba_tab_privs.table_name%type;
7: jdev_grants grant_collection;
8: type grantee_collection is table of sys.dba_tab_privs.grantee%type;
9: jdev_grantees grantee_collection;
10: pkg_name sys.dba_tab_privs.table_name%type;
4: not_granted exception;
5: pragma exception_init(not_granted, -1927);
6: type grant_collection is table of sys.dba_tab_privs.table_name%type;
7: jdev_grants grant_collection;
8: type grantee_collection is table of sys.dba_tab_privs.grantee%type;
9: jdev_grantees grantee_collection;
10: pkg_name sys.dba_tab_privs.table_name%type;
11: grantee varchar2(130);
12: stmt varchar2(2000);
6: type grant_collection is table of sys.dba_tab_privs.table_name%type;
7: jdev_grants grant_collection;
8: type grantee_collection is table of sys.dba_tab_privs.grantee%type;
9: jdev_grantees grantee_collection;
10: pkg_name sys.dba_tab_privs.table_name%type;
11: grantee varchar2(130);
12: stmt varchar2(2000);
13: begin
14: