Home » SQL & PL/SQL » SQL & PL/SQL » stored procedure
stored procedure [message #36548] Tue, 04 December 2001 06:09 Go to next message
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 #36551 is a reply to message #36548] Tue, 04 December 2001 06:27 Go to previous messageGo to next message
tinel
Messages: 42
Registered: November 2001
Member
use the dbastudio, it's verry easy to use

----------------------------------------------------------------------
Re: stored procedure [message #36553 is a reply to message #36551] Tue, 04 December 2001 06:44 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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';

----------------------------------------------------------------------
Previous Topic: Using instr and substr
Next Topic: oracle resource not being released -2
Goto Forum:
  


Current Time: Mon Mar 30 02:32:33 CDT 2020