Pl/Sql Built-in packages

[daph]

Hi!

I couldn't find a forum for Pl/Sql so, I thought I'd try this one, just in case someone uses this language for SQL Queries and such.

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

 

[petersJazz]

PL/SQL is Oracle specific, so put the question in Oracle forum.

By the way, dont know the answer.

 

[karluk]

This is likely a permissions issue. You have to make sure that the package owner has execute permission on dbms_lock. Also, this execute permission should be granted directly to the owner, rather than obtained via a role. I don't think roles are active when a procedure executes.