Home » SQL & PL/SQL » SQL & PL/SQL » Procedure (9i)
Procedure [message #359844] Tue, 18 November 2008 05:59 Go to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
My friend created a procedure account_transaction. And he used that procedure in many places. I want to see all those places where this procedure is call.HOw will i see that.I am working in SQL* prompt environment.
Re: Procedure [message #359845 is a reply to message #359844] Tue, 18 November 2008 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What if the procedure is called from an application far outside the database?

Regards
Michel
Re: Procedure [message #359848 is a reply to message #359845] Tue, 18 November 2008 06:04 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
I am logging in his account.It is called from many places in his database only.
Re: Procedure [message #359850 is a reply to message #359848] Tue, 18 November 2008 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain what you mean by "place".

Regards
Michel
Re: Procedure [message #359854 is a reply to message #359850] Tue, 18 November 2008 06:07 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
means that procedure called from other procedures.
Re: Procedure [message #359856 is a reply to message #359854] Tue, 18 November 2008 06:12 Go to previous messageGo to next message
rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore
Member
One of my colleagues tell me that we can set sql environment variable code=true and then run that procedure account_transaction. But i am geeting exactly.
Re: Procedure [message #359858 is a reply to message #359854] Tue, 18 November 2008 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query all_source view.

Regards
Michel
Re: Procedure [message #359861 is a reply to message #359858] Tue, 18 November 2008 06:24 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Query public_dependency

Previous Topic: Find a break in number sequence
Next Topic: Please help in converting a script to query for getting Net Entitlement (merged)
Goto Forum:
  


Current Time: Sat Dec 10 18:53:47 CST 2016

Total time taken to generate the page: 0.10716 seconds