View Procedure Text
Hai, I have a procedure in the database and suppose if I need to view the content of the procedure please let me know the steps to be done. Thanks in advance
Hi Rafi, Just query user_source or dba_source with group by of name column in that. Cheers, Kamalesh JK
if you can connect using forms/reports developer installed on your desktop , connect to your database using forms/reports scroll down to database objects, go to the schema where procedure is created and then double click on procedure to view the procedure this is one of the options one can use if formatting in SQL is a problem for viewing the procedure content
Just run this after connecting to DB as system or sys select text from dba_source where name=<procedurename>; if you connect as schema user you can query select text from user_source where name=<procedurename> and type=<type of PLSQL> type can be the following. TYPE FUNCTION PACKAGE PACKAGE BODY PROCEDURE TRIGGER TYPE TYPE BODY
It works fine and thanks a lot.....