Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql parsing
pl/sql parsing [message #244955] Thu, 14 June 2007 13:01 Go to next message
lib_malibu
Messages: 2
Registered: June 2007
Junior Member
Hello!
I would like to make a parser for pl/sql code so I could get detailed information about dependencies between objects (information from table all_dependencies isn't enough). Is there any oracle tool that can help me to achieve this goal?

Thank you
Re: pl/sql parsing [message #244958 is a reply to message #244955] Thu, 14 June 2007 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
>Is there any oracle tool that can help me to achieve this goal?
Please elaborate on what exactly you are trying to achive.
What OS name & version?
Which Oracle version to 4 decimal places?
Re: pl/sql parsing [message #244962 is a reply to message #244955] Thu, 14 June 2007 13:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
%_dependencies is the only thing Oracle provides to show dependencies.
It does not provide a parser to show other things (which ones?).

Regards
Michel
Re: pl/sql parsing [message #244989 is a reply to message #244962] Thu, 14 June 2007 16:24 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
%_dependencies is the only thing Oracle provides to show dependencies.
What about utldtree.sql that will provide a more useful display of information on dependencies. (Although I have no idea if that is what the OP is asking for of course.
Re: pl/sql parsing [message #245006 is a reply to message #244989] Thu, 14 June 2007 22:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
utldtree.sql just generates the same thing that a "connect by" on dba_dependencies plus data on cursors but I don't think OP wants cursor dependencies.

Regards
Michel
Re: pl/sql parsing [message #245133 is a reply to message #244958] Fri, 15 June 2007 04:46 Go to previous messageGo to next message
lib_malibu
Messages: 2
Registered: June 2007
Junior Member
I'm working in windows 2000 professional 5.00.2195 and using Pl/SQL Developer version 7.1.1 and oracle 9i Enterprise Edition Release 9.2.0.7.
What I really want is, for exemple, instead of the objects related to a package, I wanna now to witch procedure or function in that package that object is related to. Also, when I have a dependency with a table, I wanna now if that procedure/function only writes or only reads (or both) on the table.
I hope I have made myself clear Smile
Thank you
Re: pl/sql parsing [message #245136 is a reply to message #245133] Fri, 15 June 2007 04:56 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle tracks only dependencies between objects packages are objects, standalone procedures are objects, procedures inside of a package are not objects.
So you can't find this information inside Oracle.

Read/write access depends on instructions that may be dynamic that is only known at execution time. So impossible to know this information a priori.

Regards
Michel
Previous Topic: Getting some wierd compile errors that i can't solve......Please Help
Next Topic: How this function works??
Goto Forum:
  


Current Time: Mon Dec 05 15:05:23 CST 2016

Total time taken to generate the page: 0.05764 seconds