ERPstuff - Oracle EBS Community

Hi,

I want to take a PL/SQL procedure from the Server...

can anyone suggest me the directory in which we can find the pl/sql and also the extension of the files......

Thanks,

Hi Uma,

Please log on to the server database,then use this query to find out the PL/SQl Procedure.

Select * from user_objects where OBJECT_TYPE='PROCEDURE'

It will shows the list of all procedure names.
Extension of the file is .SQL

If you have any queries please let me know.

Try these tools,

http://www.allroundautomations.nl/plsqldev.html
http://www.toadsoft.com/

Hi admin,

Thanks for your reply.
The below given query helped me to take the content of the pl/sql program regsitered in apps for taking few reports.

SELECT text FROM user_source where name = 'File name ' AND type =
'PROCEDURE' ORDER BY line;

Hope this will be useful to Others