Debugger doesn't work

[Buck]

Hi,

i've some trouble with the Debugger Tool.

First: I've tried to use this tool with my Scott/Tiger account. Is that possible? Or do i need special privileges?

When i try to debug - for example a trigger - the debugger won't show any erorrs. Even if i misspelling some words on purpose, the "CALL STACK" Windows appears and disappears. No Errors Message appears. Of course, the Trigger doesn't work properly, because the syntax is wrong, but the Debugger doesn't care.

Am i doing it the right way? I drag the code of the trigger into the "TEST WINDOWS" and press F9. Shouldn't the Debugger show me any erorrs?

Probably it's not necessary to mention it, because you already noticed it, but i'm a Newbie with PL/SQL Developer. ;-)

Any Help is appreciated!

thanks,
Stefan

PL/SQL Developer
Version 6.0.2.882
Oracle: 10g

 

[Marco Kalter]

First: I've tried to use this tool with my Scott/Tiger account. Is that possible? Or do i need special privileges?

All you need is the RESOURCE role so that you can perform development tasks. Some functions require additional priviliges though, for which you will be notified.

Am i doing it the right way? I drag the code of the trigger into the "TEST WINDOWS" and press F9. Shouldn't the Debugger show me any erorrs?

To debug a trigger, place an insert, update, or delete statement in the PL/SQL Block of the Test Window, start the debugger, and "step into" the statement. Now the debugger will step into the triggers that are fired due to this statement.