1 person found this helpful
we're looking in DBA_PROCEDURES, which doesn't appear to publish private procedures in a package - where it's in the body but not the spec.
thank you very much for the clarifications
A private package function/procedure can ONLY be called from within the package.
So the first thing you need to do is create a package PUBLIC function/procedure that calls the private one.