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
PL/Java Adoption
PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java language and hamper its adoption. First, there are a ...
Db2 12 for z/OS SQL Enhancements: Result Set Pagination
In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe us...
Free training: Toad for Oracle Fundamentals
When you buy a new product, there’s no better place to start than at the beginning—unless you’re one of those people who doesn’t read the directions. If that’s the case, then we won’t be assembling an...