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
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