Thanks for the question, Christian.
Asked: September 01, 2023 - 3:43 pm UTC
Last updated: September 04, 2023 - 1:34 am UTC
Version: 10.2.0.5
Viewed 1000+ times
You Asked
I am running a PL/SQL and during its execution the connection to the database simply disappears leaving the process unfinished. There are no error messages that make me think PL/SQL failed, it just stops.
Checking the session browser I see that it is in ACTIVE status and at some point it simply disappears.
Do you know what may be causing this abrupt disconnection?
and Connor said...
Wow ... 10.2 ?
Most likely the session has crashed, in the session where you *called* the PL/SQL, there should be an error meessage.
Try it from SQL*Plus, and also, check your alert.log - sessions that die unexpectedly will be logged there.
Is this answer out of date? If it is, please let us know via a Comment