Toad World® Forums

PLS-00302 trying to use sys.DBMS_SESSION.sleep (2);

After installed TOAD I start receiving PLS-00302 on my procedure with sys.DBMS_SESSION.sleep (2);

  • Documentation says DBMS_SESSION does not require any additional grant.

Can someone help me ?

What is the database version?

The sleep procedure used to be part of dbms_lock, but from Oracle 18c, it moves to dbms_session and is depricated in dbms_lock.

Until 18c, you need dbms_lock.sleep.

Norm. [TeamT]

1 Like

Thank you very much Norm.

You are correct, I tried to compile over 11.2 version. I'm sorry. Using 18c we are good. No problem in TOAD 14.

Luis H>

1 Like