debug (F9) starts in normal mode (F8)

[Arjan Hapers]

Hello,
I try to debug from within a test window, by hitting the F9 key. The execution starts but it seems to start in the normal mode (F8). The toolbar stays disabled and the execution finishes correctly. Can any one tell me what to do to get in the debug mode?
Arjan

 

[Marco Kalter]

Can you let me know your Oracle Server version?

 

[inanme]

Hi Marco,

I am having the very problem. I can debug any procedure on oracle 9.2.0.7, but on the other hand i can not debug on oracle 10.2.0.2. I had thought some privilege missing before i saw this post.

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
Windows XP version 6,0 (build 2600) Service Pack 2

Using
Home: OraClient
DLL: c:\oracle\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Character size: 1 byte(s)

 

[Marco Kalter]

On Oracle10g your program unit must be compiled "with 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.

 

[inanme]

Marco,

How can i compile anonymous block with debug information? Actually the problem mentioned above occurs when debugging anonymous blocks.
configuration is the same as above.

"Add debug information when compiling" this option is checked.

 

[Marco Kalter]

For anonymous blocks this does not yet work. If you send me an e-mail, I can provide you with a fix though.

 

[Matthias Schulz]

Hello Marco,

I have the same problem with debugging anonymous blocks.

So could you please make this fix public?

Thank you in advance,

Matthias Schulz

 

[Matthias Schulz]

Hello Marco,

I have changed my profile so that you can send me E-Mails from now on.

So just in case you can't make the fix public, it would be very kind to send me the fix via E-Mail too.

Thank you in advance,

Matthias Schulz