Debugging Does not Stop at Breakpoint

[shantanu]

Hi,

I am trying to debug a PLSQL procedure (say Hello_World) and I start the debugging by calling a test script which calls this procedure (Hello_World). When I try to debug the test script and click on Step Into, it does not step in to the Hello_World procedure, but simply executes it. What am I missing?? I am using oracle 9i and PLSQL Developer 5.1.3.704

Thanks
Shantanu

 

[orca777]

Hi,
are you the owner of the test-procedure? ( hello ... )
You can only debug PL/SQL-Objects which re yours.
Orca

 

[shantanu]

I have created the stored procdure, so I am hoping that I should be the owner.

Note: I am new to Oracle, primarly being working on SQL Server.

Thanks
SN

 

[Marco Kalter]

In that case it should work just fine. What is the PL/SQL code of the Hello_World procedure?

------------------
Marco Kalter
Allround Automations

 

[shantanu]

The hello world procedure takes in a parameter i.e. the name of the person and the does screen output of Hello... with the person name.

Here is the code:

create or replace procedure Hello_World(
pi_name in varchar2
) IS
lv_message varchar2(60);
BEGIN
lv_message := 'Hello World! How are you ' | | pi_name;
dbms_output.put_line(lv_message);
END Hello_World;

The above procedure compiles succesfully and so I right click on the procedure name and click on 'TEST' and here is the code for that:
begin
-- Call the procedure
hello_world(pi_name =>

i_name);
end;

I set the pi_name = 'shantanu' then click on the debug->Start. It then highlights the first line i.e. hello_world(pi_name =>

i_name); and then when I click Debug->Step Into it just finishes the execution without going into the Hello_world procedure (which was what I wanted to debug).

Is there some scripts I need to run, or something extra to install for the debugger to run.

Thanks
Shantanu

 

[Marco Kalter]

Are you perhaps connected as SYS? If so, disable the "Step over SYS objects" preference (Tools > Preferences > Debugger tab page).

------------------
Marco Kalter
Allround Automations

 

[shantanu]

That did it. It is working now. Thanks a lot for your help.