Home » SQL & PL/SQL » SQL & PL/SQL » Problem with packages between Users
Problem with packages between Users [message #350189] Wed, 24 September 2008 05:48 Go to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Hello all,

I am facing the following problem:

I have two users/schemas e.g PP_STATS & SMS_DATA.
For PP_STATS I am doing some changes in package e.g body.
In an SMS_DATA's trigger the body i being called so when I do a compile after the changes of body then the trigger of the other user should see the changes.
The problem is that is is not done meaning that user SMS_DATA cannot see the new body.
Both users have rights to see each other.

To avoid that for every change I do in body I have to rename it to body_1, body_2 etc of PP_STATS and then do the same change to the trigger of SMS_DATA in order to be able to see the updated package.

Could anyone know why this happens or face the same problem before?
Any idea?

thanks in advance
Mimas
Re: Problem with packages between Users [message #350194 is a reply to message #350189] Wed, 24 September 2008 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't kinow if someone understands what you mean I don't.
If a trigger depends on a package and this is modified then the trigger is automatically recompiled next time it is executed. You have nothing to do.

Regards
Michel
Re: Problem with packages between Users [message #350197 is a reply to message #350189] Wed, 24 September 2008 06:14 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
There are two different users in the same schema. Each user contains several packages.
User A calls user's B packages.
When an updated version of user's B package is created, User A cannot see the change and will keep on calling the old package (the non updated one).

Both users have permissions to call the packages of each other.
Re: Problem with packages between Users [message #350199 is a reply to message #350197] Wed, 24 September 2008 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
User A cannot see the change

This is wrong if User A uses User B package, it uses the latest version. Oracle does not keep several versions of a package.

Regards
Michel
Re: Problem with packages between Users [message #350206 is a reply to message #350199] Wed, 24 September 2008 06:46 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Michel Cadot wrote on Wed, 24 September 2008 14:26
Quote:
User A cannot see the change

This is wrong if User A uses User B package, it uses the latest version. Oracle does not keep several versions of a package.

Regards
Michel


Thanks for the answer.
This is what I know so far but why then I am facing this problem and only when I change the name of the package then it can be seen from the other user!!
Re: Problem with packages between Users [message #350209 is a reply to message #350206] Wed, 24 September 2008 06:55 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Show us EXACTLY what you are doing.
Re: Problem with packages between Users [message #350216 is a reply to message #350189] Wed, 24 September 2008 07:37 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
How can I find out which package a user is using ? e.g How can I see which package User A is using in any point of time??
Re: Problem with packages between Users [message #350225 is a reply to message #350197] Wed, 24 September 2008 07:56 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Mimas wrote on Wed, 24 September 2008 07:14
There are two different users in the same schema. Each user contains several packages.


This makes no sense in the Oracle world. You have to clarify your statement.
Re: Problem with packages between Users [message #350227 is a reply to message #350189] Wed, 24 September 2008 08:03 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Also, when you show us exactly what you are doing, show us any synonyms you've got in there...
Previous Topic: sql help
Next Topic: ORA-00001: unique constraint
Goto Forum:
  


Current Time: Fri Dec 09 11:54:41 CST 2016

Total time taken to generate the page: 0.11521 seconds