Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Debugger connection to debuggee process has been lost.

User_E7ASAApr 12 2021

Hello,
I am debugging a PL/SQL in sql developer unit with dbms_debug configured.
The debugger disconnects during a long running sql after ca. 1 minute. The connection is still active after this and can be used for queries. When I close sql developer, I am being asked to close the debugger process.

Connecting to the database XX.
Debugger attempting to connect to database.
Executing PL/SQL: DECLARE
id VARCHAR2( 30 );
BEGIN
id := DBMS_DEBUG.initialize( 'XX:1618217911607', 0 );
DBMS_DEBUG.debug_on( TRUE );
END;
Debugger connected to database.
Source breakpoint: PKG_MDL.pls:44
Debugger connection to debuggee process has been lost.
ORA-01013: user requested cancel of current operation
Executing PL/SQL: BEGIN
DBMS_DEBUG.debug_off();
END;

Help is highly appreciated!

Comments
Post Details
Added on Apr 12 2021
8 comments
1,347 views