DBMS_LOCK.SLEEP must be declared?
913578Jan 25 2013 — edited Jan 25 2013Hi,
CREATE OR REPLACE FUNCTION TEST_SLEEP
(
TIME_ IN NUMBER
)
RETURN INTEGER IS
BEGIN
DBMS_LOCK.sleep(seconds => TIME_);
RETURN 1;
EXCEPTION
WHEN OTHERS THEN
RAISE;
RETURN 1;
END TEST_SLEEP;
Giving error: PLS-00201: identifier 'DBMS_LOCK' must be declared
what can be the reason? even i have tried with SYS.DBMS_LOCK.. still not working.