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

Your email address will not be published. Required fields are marked *