Re: ORA-04068 on New Session

 Hi Dominic,
Yes, that procedure also clears the error, thanks. I guess it's an understanding question on my part:   Why do I need to call this in a brand new session?   Surely I don't have any session state at this point which would need to be discarded? Thanks you!Charlotte.

    On Wednesday, January 10, 2024 at 03:48:26 PM GMT, Dominic Brooks <dombrooks_at_hotmail.com> wrote:  

 What happens if you call dbms_session.reset_package? https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SESSION.html#GUID-CEC0FC4B-6520-4A79-A0C9-32C1ACAC552A Cheers,
DominicFrom: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Charlotte Hammond <dmarc-noreply_at_freelists.org> Sent: 10 January 2024 15:22
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> Subject: ORA-04068 on New Session 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