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