problem with calling proceedures

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 18 Sep 2003 22:39:40 -0800
Message-ID: <F001.005D06B7.20030918223940@fatcity.com>

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: hrishys_at_yahoo.co.uk

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: ListGuru_at_fatcity.com (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). Received on Fri Sep 19 2003 - 01:39:40 CDT