Oracle : how to create the package - utl_recomp in a database
Posted on 2009-04-12
When I tried to granting the execute privilege for the package- utl_recomp to one of our database user through "sys", I am getting the below error message.
grant execute on sys.utl_recomp to david
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
It is evident from the above error message that mentioned package is not available in the database.
I would need the expert advice ito resolve this issue. please suggest way forward on this issue.