pl/sql remote debugging from Eclipse.
Hello,
we have the setting for Eclipse - Weblogic - SQL developer.
I am able to debug pl/sql in sql developer from Eclipse when i type the following dbms_debug_jdwp line inside java code.
//For Remote debugging only
CallableStatement debugStatement = connection.prepareCall
("begin DBMS_DEBUG_JDWP.CONNECT_TCP('localhost', 4000 ); end;");
debugStatement.execute(); //Create remote debug session.
But, architect does not like the idea that developers put the unnecessary code inside the java file. If i can create the JDWP remote debug session from Eclipse without putting the code, the architect will accept.
Is there any way to create remote debug session without typing CallableStatement statement inside Eclipse?
It does not have to be from Eclipse. If i can create the remote session from Weblogic or oracle....
One thing i can think of is create the trigger during oracle login...
Thanks,