In this forum you can share stuff related to Oracle 11g, 10g, 9i.
-
anu_uma
- Posts: 456
- Joined: Sat Feb 03, 2007 4:39 am
- Location: India
-
Contact:
Post
by anu_uma »
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,
-
siva sankar
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
Post
by siva sankar »
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.
-
admin
- Posts: 2063
- Joined: Fri Mar 31, 2006 12:59 am
- Location: Pakistan
-
Contact:
Post
by admin »
-
anu_uma
- Posts: 456
- Joined: Sat Feb 03, 2007 4:39 am
- Location: India
-
Contact:
Post
by anu_uma »
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
Users browsing this forum: No registered users and 0 guests