Oracle Application Express (MOSC)

MOSC Banner

Remote Debugging with SQL-Developer (APEX)

edited Dec 10, 2013 4:23AM in Oracle Application Express (MOSC) 1 commentAnswered
Hello all,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center