Re: ORA-04068 on New Session

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Wed, 10 Jan 2024 15:47:25 +0000
Message-ID: <DBAPR02MB647015F02D0AB60BBD3B7E95A1692_at_DBAPR02MB6470.eurprd02.prod.outlook.com>

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,
Dominic

---

From: 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

Received on Wed Jan 10 2024 - 16:47:25 CET