ORA-01036 in Debug Session

[ams]

Hello !

I am quit new with PL/SQL Dev. and I am on my very first evaluation of the debugger. But I cannot start. Even with a one-line Test-Procedure calling a 3 line PL/SQL-Procedure I got the error message "ORA-01036 illegal variable name/number".

I reduced it up to "no call" and up to nothing (empty Test Window) but after starting the debugger (F9) the message occurs again.

(W2000, Oracle 10.0.1)

What did I wrong ?

Thanks in advance !

Andree

 

[Marco Kalter]

ORA-01036 indicates that you have declared a bind variable in the bottom section of the Test Window that is not present in the text of the PL/SQL Block (e.g. :my_variable).

The easiest way to familiarize yourself with the Test Window is to right-click in the Object Browser on a function you want to debug, and select the "Test" function from the popup menu. This will create a Test Script with all variables correctly setup.

See also chapter 4 in the User's Guide.

 

[ams]

That's it !
Thank you
A.