Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Acessing stored procedures using sqlplus

Re: Acessing stored procedures using sqlplus

From: Cyber Hunt <cyber_hunt_at_hotmail.com>
Date: Thu, 9 Dec 1999 19:55:34 -0500
Message-ID: <82pj44$2pi0$1@newssvr04-int.news.prodigy.com>

Hi Payal,

Try using the view user_objects. It also has a column called Object_Type - which contains values such as Procedure, Function etc. You will need to use the ORDER BY clause for extracting the source of a stored procedure as it is stored line by line. For recreating the procedure you can extract it and then Recreate it by using the command -
Create or Replace procedure xyz as
begin
....
End;

Hope this solves your problem.

Mahesh Received on Thu Dec 09 1999 - 18:55:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US