ORA-04068 on New Session

From: Charlotte Hammond <"Charlotte>
Date: Wed, 10 Jan 2024 15:22:54 +0000 (UTC)
Message-ID: <1432383762.11268685.1704900174536_at_mail.yahoo.com>



Hi All,
I have a PL/SQL package which contains global variables - when this is changed I get an ORA-04068 when calling it.   So far, as expected. However, what I don't understand is....
1.   Why do I get this if I call the package in a brand new session?   Surely this does not have any state to be discarded? 2.   Why do I get this until I explicitly recompile the package?   I thought Oracle would compile it for me if this error was raised? Details:Oracle 19.18.  The changed package isn't called directly but is called by a package which in turn called by another package which I call directly, as the first thing I do after logging in (using SQLPlus). Any illumination appreciated!
Thank you!Charlotte

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 10 2024 - 16:22:54 CET

Original text of this message