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!

Package: Difference between calling external procedures vs. internal

594752Sep 20 2007 — edited Sep 20 2007
I have a package which has a bunch of procedures. I have decided to move one of the procedures outside the package because there is a user that needs control over the SQL in it. I pass 2 dates into it so I don't think I can create a view. My question is this:

What is the difference in syntax to call a procedure outside the package as opposed to one inside the package?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2007
Added on Sep 20 2007
16 comments
1,163 views