Get the source file of any 'Pl/Sql Stored Procedure' on current program

All of us knows how to find-out the source of a stored procedure in database using TOAD.

Using SQL*Plus, to retrieve the sources, please do the following :

1. From the Define concurrent Program forms, query your PL/SQL concurrent program then note Executable Name  .

2. Go to the Define Executable forms, query the executable name of step 1 then note the Execution File Name.

An executable file name is generally formatted as :

Package_name.Procedure

3. To retrieve the source, connect to apps then run the following sql statement from SQL*Plus :

set long 20000
set pages 9999
set lines 80
select text from user_source
where name =''
order by line
/

Cheers!!!

Related Posts by Categories