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!

Executing a package from a different schema.

570330Apr 2 2007 — edited Apr 2 2007
I have a problem in creating a package,say PKG in schema A, which accesses another package PKG from an other schema say schema B.All execute privs are given for Schema A from Schema B .When i try to compile this package,it gives an error "Carrier_spec_Generate_Fare is not a Procedure and is undefined".

FYI,i am able to execute this package from schema A,but not able to call this from an other package.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2007
Added on Apr 2 2007
5 comments
1,378 views