Hi,
it's first time I try to use debugging in SQL Developer.
After clicking the Debug icon and running the stored procedure I get:
Connecting to the database XXXX
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.81.xxx.yy', '59412' )
ORA-00942: table or view does not exist
Process closed.
Disconnecting database XXXX
DBA told me that on that user there's the debug connect session privilege
In previous situation, I've used SQL Developer 3.0 whereas by using SQL Developer 19.2 I get :
Connecting to the database XXXX
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.81.xxx.yy', '59412' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process closed.
Disconnecting database XXXX
As I work by VPN, which IP shoud I put in Remote Debug section of my connection? Could that be the problem?
Thanks in advance!
Mark