Maybe someone can tell me where to find this. I have an identity management product that uses Oracle as its backend database. Some of the processes use stored procedures in that database to return True / False or other conditional information. I use TOAD all the time to view the data in this database but I cannot seem to figure out where to view these store procedures and what information they use to arrive at their results. Can anyone tell me how to use TOAD to find and view these procedures?
-Brandon
You can find them in the Schema Browser. See attached image.
From: breal5825 [mailto:bounce-breal5825@toadworld.com]
Sent: Thursday, February 20, 2014 9:57 AM
To: toadoracle@toadworld.com
Subject: [Toad for Oracle - Discussion Forum] Viewing Stored Procedures
Viewing Stored Procedures
Thread created by breal5825
Maybe someone can tell me where to find this. I have an identity management product that uses Oracle as its backend database. Some of the processes use stored procedures in that database to
return True / False or other conditional information. I use TOAD all the time to view the data in this database but I cannot seem to figure out where to view these store procedures and what information they use to arrive at their results. Can anyone tell me
how to use TOAD to find and view these procedures?
-Brandon
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Assuming you don’t know the name of the package/procedure, but do know the table name, I would suggest…
-
Open Schema Browser
-
Select the table you know the package is modifying
-
On the Right Hand Side, select the ‘Used By’ tab
From: breal5825 [mailto:bounce-breal5825@toadworld.com]
Sent: Thursday, February 20, 2014 10:57 AM
To: toadoracle@toadworld.com
Subject: [Toad for Oracle - Discussion Forum] Viewing Stored Procedures
Viewing Stored Procedures
Thread created by breal5825
Maybe someone can tell me where to find this. I have an identity management product that uses Oracle as its backend database. Some of the processes use stored procedures in that database to
return True / False or other conditional information. I use TOAD all the time to view the data in this database but I cannot seem to figure out where to view these store procedures and what information they use to arrive at their results. Can anyone tell me
how to use TOAD to find and view these procedures?
-Brandon
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Bingo! The Schema Browser is what I was looking for. Thanks guys. I’m fairly new to TOAD having come from a MS-SQL environment so many thanks for pointing me in the right direction. 
