PLS:00123 with Insert statements

[sqldev]

Hi,

I am trying to insert 5000 records at a time via pl/sql developer and getting PLS:00123 error. I have tried turning off "Tools-Preferences-Debugger-Add debug information when compiling" option. It still doesn't work.
Appreciate your help.

Thanks.

 

[Marco Kalter]

PLS-00123 is a compilation issue, and is not typically related to inserting records. Perhaps there is a trigger that refers to an invalidated program unit? Implicit recompilation of this invalidated program unit could then lead to PLS-00123.

Perhaps you can use the Compile Invalid Objects tool to ensure that all objects are valid.