Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synonym for procedure in a package (19c)

JackKSep 14 2021

Hi All,
I know that in 12c it was not possible to create a synonym for a proc/func inside a package.
Is this still true in 19c?
If yes then how to overcome this limitation?
I'd like to have overloaded procedure "pr_a" to DBMS_OUTPUT.put_line an array of objects of several types.
It is also not possible to create overloaded standalone procedure.
So... how may I have an overloaded procedure possible to execute by providing its name only (without any package prefix)?

This post has been answered by JackK on Sep 16 2021
Jump to Answer
Comments
Post Details
Added on Sep 14 2021
14 comments
3,029 views