Pl/Sql Built-in packages 1

[daph]

Hi!

Here's my little problem,

I was trying to use the sleep(); procedure that is built in a package called DBMS_LOCK. I tried calling it by typing DBMS_LOCK.sleep(20); but I got this error message:

PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared
PL/SQL: Statement ignored

Am I missing something here? I thought packages could be used anywhere in a procedure. Do I need to declare something before using it?

Thanks!

daph

 

[VSU]

You have no execution privilege on SYS.DBMS_LOCK package.

Connect to database as user SYS

Then
[tt]
GRANT EXECUTE ON dbms_lock TO my_user;
[/tt]