Check to see whether you have an object named the same as the owner of the procedure. When this is the case, Oracle thinks that the user name in the anonymous block is actually the object name. We recommend either renaming the problematic object or manually removing the user name from the anonymous block in the Set Parameters window.
Related Articles
Toad for Oracle Editor – How to Run Very Large Scripts
One from Wendy Penfold on the Toad lists: Hi, I need to load a large file of insert statements–44,000. The file is too large to open in the Toad editor, it hangs Toad. Is there a way I can run the sc...
Toad for SQL Server – Configuration and Layout
Watch as Toad Expert, Robert Pound, demonstrates the configuration and custom layout capabilities in Toad for SQL Server....
Oracle Redo Logs – Monitoring
When monitoring redo logs, instead of direct views for statistics, we must look at statistics based on redo log and log writer process statistics. These views are: V$STATNAME V$SESSION V$PROCESS V$SE...
