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>
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-lReceived on Wed Jan 10 2024 - 16:22:54 CET