Re: How to modify an stored procedure ?
From: AMARENDRA B NETTEM <nettama_at_charlie.acc.iit.edu>
Date: 1996/04/25
Message-ID: <317F80DC.5165_at_charlie.acc.iit.edu>#1/1
Date: 1996/04/25
Message-ID: <317F80DC.5165_at_charlie.acc.iit.edu>#1/1
MCC wrote:
>
> I want to modify an existing stored procedure, how can I get a copy of it and
> modify it?
>
> Thanks in advance,
> Duffy
Look into USER_SOURCE Table
select text user_source
where name ='procedure_name' and spool this statement.
hope this helps
AMARENDRA Received on Thu Apr 25 1996 - 00:00:00 CEST