Home » SQL & PL/SQL » SQL & PL/SQL » Object dependencies in PL/SQL code (Oracle)
Object dependencies in PL/SQL code [message #571905] Mon, 03 December 2012 14:40 Go to next message
jvsjvs
Messages: 3
Registered: December 2012
Junior Member
Hi everyone,
Did anyone interest in the topic search for dependencies between objects in the database?
I want to see the PL/SQL code which is an appeal to a particular procedure or function or package and where and how does a table use in any PL/SQL code.
Often do you have a need to get answers to these questions?
I'm developing such tool now and I want to know, if everybody interested to one.
Re: Object dependencies in PL/SQL code [message #571906 is a reply to message #571905] Mon, 03 December 2012 14:53 Go to previous messageGo to next message
BlackSwan
Messages: 21970
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


query DBA_DEPENDENCIES
Re: Object dependencies in PL/SQL code [message #571908 is a reply to message #571905] Mon, 03 December 2012 14:56 Go to previous messageGo to next message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Often do you have a need to get answers to these questions?


We have this question at least once each month this question.
See the scripts at:
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: Mon, 03 December 2012 14:57]

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #571978 is a reply to message #571908] Wed, 05 December 2012 01:21 Go to previous messageGo to next message
jvsjvs
Messages: 3
Registered: December 2012
Junior Member
I say about an object usage presentation, not about its relations only.
Do you want to know, how opbject used?
If it's a table - what's DML?(insert/select/...)
If it used in a package - which procedure of package uses in?
The object usage in an external objects - Oracle*Forms/Reports,Flat/Word files, Informatica.
What do you think about one?
Re: Object dependencies in PL/SQL code [message #571980 is a reply to message #571978] Wed, 05 December 2012 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Scan the code.

Regards
Michel
Re: Object dependencies in PL/SQL code [message #572000 is a reply to message #571980] Wed, 05 December 2012 05:15 Go to previous messageGo to next message
Littlefoot
Messages: 18846
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I *think* that @jvsjvs offers a brand new piece of software (he developed), which displays all those information. He is not asking "how to do this" or "how to do that", but whether anyone here is interested in using (buying?) such a program.

If that's so, maybe it should be moved to Marketplace. If I'm wrong, oh well.
Re: Object dependencies in PL/SQL code [message #572005 is a reply to message #572000] Wed, 05 December 2012 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah? Sure it is not clear and can be read in this way.
Waiting for OP confirmation...

Regards
Michel
Re: Object dependencies in PL/SQL code [message #572013 is a reply to message #572005] Wed, 05 December 2012 06:26 Go to previous messageGo to next message
jvsjvs
Messages: 3
Registered: December 2012
Junior Member
May be you right, but this don't cancel my question.
I'm checking now if anybody interest in the topic.
Maybe anybody sign such tool.
What's the matter? Do I advertise anything?
All answers I see I can select from *_dependencies.
Maximum + some script. This answer was 20 years before, too.
Sorry, that isn't answer now.
Michel, do you have database application only?
Each month do you check database only?
What's about anything else?

[Updated on: Wed, 05 December 2012 06:26]

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #572015 is a reply to message #572013] Wed, 05 December 2012 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 57646
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry but nobody understands your question and your point to create this topic.
Maybe you can explain us with sentence longers than 4 words and using a style that is not telegram one.

Regards
Michel

[Updated on: Wed, 05 December 2012 06:42]

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #572068 is a reply to message #572015] Wed, 05 December 2012 15:34 Go to previous message
Littlefoot
Messages: 18846
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I don't know about everybody, but I'm quite sure that I don't understand the purpose of this so called discussion any more.
Previous Topic: regexp_substr Ending with Number
Next Topic: triggers dropped (unable to restore it)
Goto Forum:
  


Current Time: Thu Apr 24 10:49:01 CDT 2014

Total time taken to generate the page: 0.09882 seconds