ORA-3113

[Hoa]

Hi,

I am having problwm with ORA-3113 while compliting procedures. I have tried to run c:\PLSQL developer\plsqldev debug and got this:

11/9/2005 9:47:11 AM Application started
11/9/2005 9:47:30 AM AddPlugInPopups Start 0
11/9/2005 9:47:30 AM AddPlugInPopups End
11/9/2005 9:47:35 AM MainForm Closing
11/9/2005 9:47:35 AM MainForm Closed
11/9/2005 9:47:35 AM MainForm Destroying
11/9/2005 9:47:35 AM MainForm Destroyed

Could you pls let me know how to sovle the problem?

Thanks
Hoa

 

[Marco Kalter]

If a compilation causes such an error, 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.

 

[Hoa]

Hi,

It works very well now. Thanks alot.

Hoa