Remote Debugging with SQL-Developer (APEX)
I have a problem with the Remote Debugging functionality in SQL Developer.
I want to debug a fuction that generate a SQL-Statement. This SQL is the basic of a report in APEX.
I grant the privilege DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE for the user.
This is the PL/SQL in the report region:
declare
v_sql varchar2(32767);
begin
dbms_debug_jdwp.connect_tcp('192.168.2.1', 4200);
v_sql := generate_sql(:P1_TABLENAME);
dbms_debug_jdwp.disconnect;
return v_sql;
end;
When I run the page i get this error:
ora-30677: session is already connected to a debugger
But I can`t debug it in SQL-Developer.