When attaching an external session for JIT (Just In Time) debugging with Oracle Forms, Toad hangs.
Steps:
1. Launch Toad and open package (compile with debug)
CREATE OR REPLACE package pkg_test is
procedure p_main
(in_term_code in varchar2,
in_num_code in number);
end pkg_test;
/
CREATE OR REPLACE package body pkg_Test is
procedure p_main
(in_term_code in varchar2,
in_num_code in number) is
v_count number := 0;
begin
null;
FOR in_num_code IN 1 .. 10 LOOP
v_count := v_count + 1;
END LOOP;
null;
end p_main;
end pkg_test;
/
2. Launch Oracle Forms and launch a Form example from zip file (see attachment)
3. Run it
4. Go to Toad and attached the session
5. It hangs and eventually Toad will crash.
Statement from SQL Monitor that Loops over and over till it times out and Toad crashes:
Timestamp: 14:30:10.312
DECLARE
RunInfo dbms_debug.runtime_info;
BEGIN
:RetVal := dbms_debug.continue(RunInfo, :BreakFlags, :InfoReq);
:LineNo := RunInfo.line#;
:Terminated := RunInfo.Terminated;
:BreakPoint := RunInfo.BreakPoint;
:StackDepth := RunInfo.StackDepth;
:Reason := RunInfo.Reason;
:ProgramNamespace := RunInfo.Program.Namespace;
:ProgramName := RunInfo.Program.Name;
:ProgramOwner :=RunInfo.Program.Owner;
:ProgramDBLink := RunInfo.Program.DBLink;
END;
RetVal =<null></null>
BreakFlags = 14
InfoReq = 255
LineNo =<null></null>
Terminated = 0
BreakPoint =<null></null>
StackDepth =<null></null>
Reason =<null></null>
ProgramNamespace =<null></null>
ProgramName =<null></null>
ProgramOwner =<null></null>
WORKAROUND:
None
STATUS:
Waiting for Fix in a future release of Toad for Oracle.
