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.
0 Responses so far.
Post a Comment
Thank you for your comment.
Any request and idea are welcome.