Home » SQL & PL/SQL » SQL & PL/SQL » How to view indirect dependecies
How to view indirect dependecies [message #296067] Thu, 24 January 2008 08:04 Go to next message
bs_baljeet
Messages: 2
Registered: January 2008
Junior Member
We have one package in Production database which get automatically recompile on standard release date. When it ( specification) get re-compile, it get added one line added automatically. The line is "AUTH_ID is current_user"

We are in process to find what is the root cause, why the plsql package got automatically get compile and how the pragma line can be added in the specification.

As of noew, we dont have much access on database. It is very sensitive production db. Can any one give us any hint on this. We dont have access to UTLDTREE.sql and any kind of its implementation. The database is Oracle 9i.
Can anyone give some hint on this.

Your any help on this is highly appreciated.

Thank You,
Re: How to view indirect dependecies [message #296072 is a reply to message #296067] Thu, 24 January 2008 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No line is added by Oracle above all a non default one.

Regards
Michel
Re: How to view indirect dependecies [message #296199 is a reply to message #296067] Fri, 25 January 2008 01:31 Go to previous messageGo to next message
bs_baljeet
Messages: 2
Registered: January 2008
Junior Member
The is getting added and we have seen this from last 6 months.

asnyway at least can i get the query to view the indirect dependecies.

Thank you,
Baljeet
Re: How to view indirect dependecies [message #296201 is a reply to message #296199] Fri, 25 January 2008 01:45 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237


Regards
Michel

[Updated on: Fri, 25 January 2008 01:46]

Report message to a moderator

Previous Topic: Help required with query
Next Topic: Oracle Server For store Metafile
Goto Forum:
  


Current Time: Fri Dec 02 12:43:46 CST 2016

Total time taken to generate the page: 0.05764 seconds