Hi All The issue is like this:
1. There are two schemas U1 and Test 2. There are two packages P1,P2 in both U1 and Test schemas 3. There is a call to P1 from inside a method of package P2 4. There are public synonyms P1,P2 to Test.P1,Test.P2 respectively 5. User U1 has modified his version of P1 6. From a form, connecting as U1, if P1 is called - P1 in U1's schema is called and everything works fine. 7. But, connecting as U1, if P2 is called - this calls test.P2 through the public synonym and the call to P1 from inside the package P2 is going to test.p1 and not U1.P1( U1.P1 because I got connected using U1) The expected behaviour is calls to P1 from inside P2 should take the caller's P1. (in this case U1's P1) Thanks and Regards Hrishy ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).