https://stackoverflow.com/questions/65541172/network-access-denied-at-sys-dbms-debug-jdwp
Get version 20.2 of SQL Developer. In preferences, set debugger mode to DBMS_DEBUG
Set breakpoints. Compile for debug. Click debug and enter parameters. Verify you are calling the correct function or procedure.
ORA-06508: PL/SQL: could not find program unit being called:
Check invalid objects:
select
owner
,object_type
,object_name
from dba_objects
where 1=1
and status != 'VALID'
order by owner,object_type, object_name desc
;
Program unit is likely invalid. Recompile.
Connecting to the database wsuir TEST1.
Debugger attempting to connect to database.
Executing PL/SQL: DECLARE
id VARCHAR2( 30 );
BEGIN
id := DBMS_DEBUG.initialize( '130.108.39.168:1718383716533', 0 );
DBMS_DEBUG.debug_on( TRUE );
END;
Debugger connected to database.
Source breakpoint: T_CURRIC.pls:283
Read more articles
- Log in to post comments