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: 64717
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: Mon Apr 24 06:59:22 CDT 2017

Total time taken to generate the page: 0.23527 seconds