SQL to show code of stored procedure

by lordog
by lordog

I was doing some system checking the other day and I needed to find out what a certain stored procedure did. But I couldn’t readly see how to view the code of the stored procedure. After some digging of google I found how to use SQL command to show code of stored procedure in Oracle at AjaxApp.com.

I had to make a few changes to view what I wanted and came up with this

SELECT text FROM dba_source WHERE name=’proc_name';

Of course you will need to replace proc_name with the name of the stored procedure you want to view the code of.

2 thoughts on “SQL to show code of stored procedure

  1. You can use his cut and paste method but may not get all of the correct formating. go to this web site:. . http:\www.zamzar.com. . It is a free.. . If you cannot figure it out or it does not work correctly email it to me and I will do it for you. drasnia33@yahoo.com. .

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s