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
Data preparation free trial now 90 days: Quest® extends Toad® Data...
Throughout our lives we all experience watershed moments—those public and private moments and events that become turning points in our lives. In the public sphere, these are the historical moments tha...
Toad Data Point Automation Series: Blog #5 – Using Macros in Excel
For more advanced forms of formatting use Excel macros. Macros are VBA instructions that can be triggered by Toad. By default Excel disables macros. You will need to set up Excel to use macros. When...
How to run SQL Statements across Pluggable Databases with catcon.pl
Introduction Beginning with Oracle Database 12.1.0.1.0, DBAs started to work with Pluggable Databases. There were some large migrations of several databases from 10g/11g to 12c where they were consoli...
