gram77
asked on
debugging in Sql Developer 1.0.0
I am using Oracle Sql Developer for debugging a simple procedure.
I grant the appropriate privileges:
kims>GRANT DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION TO KIMS;
Grant succeeded.
1. I create a procedure to debug:
CREATE OR REPLACE procedure
dummy_proc(param varchar2)
as
v_date varchar2(50);
begin
dbms_output.PUT_LINE('In dummy_proc ');
select to_char(sysdate,'dd-mon-rr rr')
into v_date
from dual;
dbms_output.PUT_LINE('date 1: '||v_date); <--BreakPoint
dbms_output.PUT_LINE('date is: '||param); <--BreakPoint
end;
2. I compile the code using compile for Debug tool:
3. I Debug the code:
Debugging Log:
Connecting to the database kims.world.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: ALTER SESSION SET PLSQL_COMPILER_FLAGS=INTER PRETED
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TC P( '172.24.197.122', '2281' )
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 exited.
Q1 why am i getting TNS:operation timed out?
Q2 I do not see the Pause/Run, Step Into, Step Over, Step out menu options active.
What should i do to get these?
I grant the appropriate privileges:
kims>GRANT DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION TO KIMS;
Grant succeeded.
1. I create a procedure to debug:
CREATE OR REPLACE procedure
dummy_proc(param varchar2)
as
v_date varchar2(50);
begin
dbms_output.PUT_LINE('In dummy_proc ');
select to_char(sysdate,'dd-mon-rr
into v_date
from dual;
dbms_output.PUT_LINE('date
dbms_output.PUT_LINE('date
end;
2. I compile the code using compile for Debug tool:
3. I Debug the code:
Debugging Log:
Connecting to the database kims.world.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: ALTER SESSION SET PLSQL_COMPILER_FLAGS=INTER
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TC
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 exited.
Q1 why am i getting TNS:operation timed out?
Q2 I do not see the Pause/Run, Step Into, Step Over, Step out menu options active.
What should i do to get these?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Suggest split.
As an update to my original post, I suggest upgrading to SQL Dev 1.2.