| stored procedure [message #36548] |
Tue, 04 December 2001 06:09  |
HV
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
Hi,
I have created a stored procedure in Oracle called X.
How do I retrieve it(view the code). Where does oracle store this internally?
Thanks!
----------------------------------------------------------------------
|
|
|
|
|
|
| Re: stored procedure [message #36553 is a reply to message #36551] |
Tue, 04 December 2001 06:44  |
HV
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
Is this a GUI? I need to do it from the SQL prompt. Is that possible with dbastudio?
Thanks!
----------------------------------------------------------------------
|
|
|
|
| Re: stored procedure [message #36556 is a reply to message #36553] |
Tue, 04 December 2001 09:57 |
vk
Messages: 13
Registered: December 2001
|
Junior Member |
|
|
you can use table called USER_SOURCE. like:
select text from user_source
where name='X'
----------------------------------------------------------------------
|
|
|
|
| Re: stored procedure [message #36566 is a reply to message #36548] |
Tue, 04 December 2001 21:25 |
prakash
Messages: 24
Registered: October 2001
|
Junior Member |
|
|
just desc the user_source table. or
type the query...
select text from user_source where type = 'procedure' and name='procedure_name';
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
