RE: ORA-04068 on New Session

Not a lot of information to work with here; but I’d start with this: https://support.oracle.com/knowledge/Oracle%20Database%20Products/106206_1.html

Clay Jackson
Database Solutions Sales Engineer
[cid:image001.jpg_at_01DA4399.33F51D10]<https://www.quest.com/solutions/database-performance-monitoring/> clay.jackson_at_quest.com<mailto:clay.jackson_at_quest.com> office 949-754-1203 mobile 425-802-9603

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Charlotte Hammond Sent: Wednesday, January 10, 2024 7:23 AM To: oracle-l_at_freelists.org
Subject: ORA-04068 on New Session

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.

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






(image/jpeg attachment: image001.jpg)