no longer able to debug a package

[karlJr]

plsql developer 6.0.3.893
oracle 9.2.0.5.0
xp professional v2002 sp2 - recently upgraded to this from w2000

i used to be able to debug without any problems.
here is my test script. i'm hanging when calling the hl7_msg_loader.add_update_person function. fyi: this problem is not isolated to this function only!

declare
-- Boolean parameters are translated from/to integers:
-- 0/1/null false/true/null
result boolean;
-- Non-scalar parameters require additional processing
delimiters hl7_msg_loader.msg_delim_rt;
hl7_msg_in CLOB;
begin
-- Call the function
select hl7msgbody
into hl7_msg_in
from hl7message
where hl7messageid='00000000000544265159';
delimiters := hl7_msg_loader.get_delimiters('^\|~&');
result := hl7_msg_loader.add_update_person(hl7_msg_in => :hl7_msg_in,
delimiters => delimiters);
-- Convert false/true/null to 0/1/null
:result := sys.diutil.bool_to_int(result);
end;

i must kill the session in order to get plsql to respond again.

please help!

 

[Marco Kalter]

What happens if you run this in "normal" mode (F8) instead of debug mode (F9)?

 

[karlJr]

well, after i put the : before my into variable hl7_msg_in) it ran successfully in normal mode.

according to oracle, here is the sql stmt that is currently executing.

declare
  -- Probe 2.1
  backtrace sys.dbms_debug.backtrace_table;
  program_info sys.dbms_debug.program_info;
  i integer;
  j integer;
begin
  sys.dbms_debug.print_backtrace(listing => :listing);
  begin
    sys.dbms_debug.print_backtrace(backtrace => backtrace);
  exception
    when others then backtrace.delete;
  end;
  :names := '';
  :namespaces := '';
  :owners := '';
  :lines := '';
  i := backtrace.first;
  j := 0;
  while (i is not null) and (j < 100) loop
    program_info := backtrace(i);
    :names := :names || program_info.name || chr(10);
    :namespaces := :namespaces  || to_char(program_info.namespace) || chr(10);
    :owners := :owners || program_info.owner || chr(10);
    :lines := :lines || to_char(program_info.line#) || chr(10);
    i := backtrace.next(i);
    j := j + 1;
  end loop;
end;

 

[karlJr]

happy ending. we shutdown and restarted the database and everything appears back to normal.

for now...

thanks for the assistance.