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 Data Modeler – Introduction
Overview of Toad Data Modeler's features and business values. New to Toad Data Modeler? You can download a free 30-day Trial...
Overview of developer features in Toad for DB2 – Part VIII
This video on generating reports is part eight of an overview of developer features in Toad for DB2....
Data modeling for the business analyst
Your organization wants to be more data driven, but with the massive growth in data and the multitude of different data sources at your fingertips, how can you more effectively gain the insights you n...