Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'DBMS_LOCK' must be declared error even though pr villages are assigned

HeshOct 29 2015 — edited Oct 30 2015

ODI : standard Edition Version 11.1.1

I am badly struck here and not able to move further,I am getting following error while executing the load plan.

oracle.odi.runtime.agent.invocation.InvocationException: ODI-1551: The dbms_lock acquisition failed with a sql exception 'ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_LOCK' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

'. Please check if the work repository db user has EXECUTE privilege on DBMS_LOCK package.

I can check at the DB level grants are already there.( I did not find the exact schema where my work repository resides, I find something ODI_WORK and I believe this is the one, my working repository name is WREP, and there is no schema with this name)

I have created a load plan with dummy steps and its still throwing same error.

Appreciate you help.

Regards,

Hesh

This post has been answered by Hesh on Oct 30 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2015
Added on Oct 29 2015
3 comments
4,220 views