I often times get an ORA-600 error when editing a stored package, function or procedure and then attempting to recompile it. Others who use PL/SQL Developer (same version) at my company do not get this error when following the same steps on the same db object. Any ideas as to what may be causing this?
ORA-0600 error
- Thread starter smiller
- Start date
By the way, I am able to Edit, then recompile my db objects using Recent Objects by choosing my object then right clicking on it and choosing Edit. It's when I have the object name typed in a SQL window, and right click on it to choose Edit that I get the error. Sometimes I get the error immediately after right clicking, sometimes I get it upon recompiling.
Does this only happen during compilation? If so, 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.
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.
This is an Oracle issue. You can reproduce it in SQL*Plus (or any other SQL tool) like this:
SQL> alter session set plsql_debug=true;
SQL> @yourpackagse.sql
The first command is the equivalent of the "Add debug information when compiling" preference.
SQL> alter session set plsql_debug=true;
SQL> @yourpackagse.sql
The first command is the equivalent of the "Add debug information when compiling" preference.
Similar threads
- Discussion
