debug trigger oracle10g

[Garshin Andrey]

Hi!

I have faced a problem with trigger debuging.
My action
1. open test window
2. type begin insert into a (a) values (1) ; end ;
3. push F9
4. push step into but I can not enter into trrigger body. Trigger works but debuger can not trace it step by step.

Andrey Garshin

 

[Marco Kalter]

On Oracle10g it is a requirement that the program unit is compiled with debug information. In Oracle9 and earlier, you could step through the code regardless of debug information.

There are 2 ways to accomplish this:

1. Enable the Debugger preference "Add debug information when compiling". Now you don't have to worry about debug information anymore, as each compilation implicitly adds it.

2. Right-click on the program unit in the Object Browser and select "Add debug information".

The debug information goes away if you compile it without the "add debug information when compiling" preference, or when someone else compiles it without debug info.