Home » SQL & PL/SQL » SQL & PL/SQL » Tables used in stored procedure (oracle 9i)
Tables used in stored procedure [message #357612] Thu, 06 November 2008 00:58 Go to next message
lokimisc
Messages: 88
Registered: February 2008
Member
Hi,
I have an requirement where I need to write a function/procedure which takes table name as a input and list out all the stored procedure and function in a particular schema that is using the inputted table.

Can anyone please help me out...

Thanks & Regards,
Lokesh
Re: Tables used in stored procedure [message #357623 is a reply to message #357612] Thu, 06 November 2008 01:22 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
all_dependencies.

Regards
Michel
Previous Topic: Is there any way to store the value more then 32760 in a variable.
Next Topic: spool query
Goto Forum:
  


Current Time: Fri Dec 09 09:28:45 CST 2016

Total time taken to generate the page: 0.12239 seconds