ORA-600 while compiling with PL/SQL Dev.

[Philippe Valentin]

Hi,
My colleague-developers are experiencing (very often) the "ORA-00600: internal error code, arguments: [17113]" error while they are compiling with PL/SQL Dev. Which is a normal developer activity.
The bad thing is, it works fine while using SQL/Plus.
I suspect there might be be some parameters to set in order to use the tools.
The only remedy I've found right now is to kick everybody out and to restart the database. Then, it works. But that's not a good one.

Any clue welcomed.
Thanks,

 

[Marco Kalter]

If a compilation causes such an error and works correctly in SQL*Plus, then I suspect a problem with the "debug information" mode. To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation.

If you are using PL/SQL Developer 6.0, you can explicitly exclude specific objects from debug information. On the same debugger tab page you can add a line with the name (or owner.name) of the program unit to the "NEVER add debug info for objects" list.

 

[Philippe Valentin]

Hi Marco,
Thanks for your quick answer. I understand it's a kind of bug (Am I wrong?).
Will the Corp. propose a fix in the next release?
Anyway, at least -we know.
Regards,

 

[Marco Kalter]

It's an Oracle Server bug (like all ORA-00600's). I'm not sure when it will be fixed.