Re: How to modify an stored procedure ?

In article 6219_at_charlie.acc.iit.edu, AMARENDRA B NETTEM <nettama_at_charlie.acc.iit.edu> writes:
> 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

don't forget to order it by line number!!

SQL> select line
  2 from user_source
  3 where name = 'my_name'
  4 order by line;

no rows selected

SQL> Regards

Tim Received on Fri Apr 26 1996 - 00:00:00 CEST