Procedure throws ORA-31603 when submitted as a dbms_job
682617Jun 24 2009 — edited Jun 25 2009Hi all,
I have an invoker's right package which extracts metadata using Dbms_metadata pkg. This package works fine when executed from my schema. But when I submit the same procedure as a job using dbms_jobs, it throws ORA-31603: object <object_name> of type TABLE not found in schema <my schema> . Any ideas?
Info: For the submitted job in USER_JOBS - log_user, priv_user, schema_user all show <my schema>.
My schema has got DBA role and SELECT_CATALOG_ROLE granted to it.
Thanks,
Shree