-
I have a package which contains a procedure named proc_replicate. The package is compiled with no errors, but when I try to execute the procedure it says that is INVALID. Indeed, if I check in user_objects table the status of this particular procedure is invalid. What could be the cause?
-
At the end of the package add "show errors; " then recompile it and see what happens. Once you are through, then try the executing the package on the sqlprompt and see the errors. It could be some exception and etc.
Sam