dbms_debug, any experience?

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 15 Apr 2002 19:32:52 GMT
Message-ID: <Xns91F1DB43072D9gnuegischgnueg@130.133.1.4>

Hello

I wanted to get familiar with dbms_debug - unfortunatly only with little success:

I am working on 8i ane here's what I tried:

I opened two sessions (say A and B)

In session A, I did:

SQL> select dbms_debug.initialize from dual;

INITIALIZE

---

000B008B0001

Then, in Session B:

SQL> exec dbms_debug.attach_session('000B008B0001')

PL/SQL procedure successfully completed.

Back in Session A:

SQL> exec dbms_debug.debug_on;

PL/SQL procedure successfully completed.

Then, in Session B, I want to set a breakpoint:

declare
  prog_inf dbms_debug.program_info;
  ret binary_integer;
  bp_id binary_integer;
  run_info dbms_debug.runtime_info;
begin

  prog_inf.namespace := dbms_debug.namespace_pkgspec_or_toplevel;
  prog_inf.name      := 'PPP';
  prog_inf.owner     := 'F';
  prog_inf.dblink    := null;
  prog_inf.line#     := 8;

  ret := dbms_debug.set_breakpoint(prog_inf,8,bp_id);   if ret = dbms_debug.success then
    dbms_output.put_line('set_breakpoint: success');     dbms_output.put_line('bp_id:' || bp_id);   elsif ret = dbms_debug.error_illegal_line then     dbms_output.put_line('set_breakpoint: error_illegal_line');   elsif ret = dbms_debug.error_bad_handle then     dbms_output.put_line('set_breakpoint: error_bad_handle');   else
    dbms_output.put_line('set_breakpoint: unknown error');   end if;
end;
/
set_breakpoint: success
bp_id:0

The result tells me, that it suceeded. However, the breakpoint id is 0 (it is always zero, even If I call the anonymous block again with another line number).

I have also compiled f.ppp with debug (alter procedure ppp compile debug) and ppp is a valid procedure, so...

...What am I doing wrong?

Rene

-- 
Recherchen im schweizerischen Handelsregister: 
http://www.adp-gmbh.ch/SwissCompanies/Search.php3

Received on Mon Apr 15 2002 - 14:32:52 CDT