Question: I have a procedure (or a function) in my Oracle package, but when I get a list of stored procedure names for my TStoredProc it is not listed. Why is this?

Answer: Only procedure names listed in sys.all_objects are listed, because returning these results is a fast query. To get a list of procedures in packages, each package would require parsing which would be a slow operation.

4 Responses so far.

Post a Comment

Thank you for your comment.

Any request and idea are welcome.