All Oracle Error Codes
Oracle DBA Forum
cannot revoke execute on a type with table dependents
An attempt was made to revoke execute on a type that has dependents.
Drop all table(s) depending on the type, then retry the operation, or use the FORCE option.