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
How to create an “Empty database” project in Jenkins with the help of...
In this post we are going to create a project in Jenkins that drops all objects from a database to prepare it for a clean script deployment. In order to do this in Jenkins, we need the sql script tha...
Toad Explain Plan More Advanced Options
Hi, I have used this option to show SQL bind variable content for a while, I want to show you how I avoid running SQL Trace with this Toad Explain Plan feature. Toad has also made it very easy to run ...
Crear reporte básico en iReport Designer
En esta oportunidad quiero compartir un capítulo de mi nuevo libro donde explico cómo crear un reporte básico en iReport Designer para despúes poder invocarlo en la aplicación en APEX. Crear Report...
