Re: ORA-04068 on New Session

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Wed, 10 Jan 2024 16:51:57 +0000
Message-ID: <DBAPR02MB6470D76180BCBDE9CD7A4974A1692_at_DBAPR02MB6470.eurprd02.prod.outlook.com>

No - I agree on the face of it that it seems odd but hard to debug without the code. Are you using universal connection pooling at all or anything which might inadvertently be keeping state across sessions?

---

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com> Sent: 10 January 2024 16:34
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org>; Dominic Brooks <dombrooks_at_hotmail.com> Subject: 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,
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 - 17:51:57 CET