OraFAQ Forum: SQL & PL/SQL » Object dependencies in PL/SQL code

Home » SQL & PL/SQL » SQL & PL/SQL » Object dependencies in PL/SQL code (Oracle)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Object dependencies in PL/SQL code [message #571905]

Mon, 03 December 2012 14:40

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.

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #571906 is a reply to message #571905]

Mon, 03 December 2012 14:53

BlackSwan
Messages: 20086
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

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #571908 is a reply to message #571905]

Mon, 03 December 2012 14:56

Michel Cadot
Messages: 54129
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

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?

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #571980 is a reply to message #571978]

Wed, 05 December 2012 01:25

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Scan the code.

Regards
Michel

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #572000 is a reply to message #571980]

Wed, 05 December 2012 05:15

Littlefoot
Messages: 16933
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.

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #572005 is a reply to message #572000]

Wed, 05 December 2012 05:54

Michel Cadot
Messages: 54129
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

Report message to a moderator

Re: Object dependencies in PL/SQL code [message #572013 is a reply to message #572005]

Wed, 05 December 2012 06:26

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

Michel Cadot
Messages: 54129
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

Littlefoot
Messages: 16933
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.

Report message to a moderator

Previous Topic:	regexp_substr Ending with Number
Next Topic:	triggers dropped (unable to restore it)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 13:59:06 CDT 2013

Total time taken to generate the page: 0.89261 seconds