Re: How to modify an stored procedure ?

In Article<4lqgmj$bbg_at_flonk.uk.sun.com>, <timj_at_baa.uk.sun.com> write:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.internetmci.com!nntp-hub2.barrnet.net!venus.sun.com!uk-usenet.uk.sun.com!usenet
> From: timj_at_baa.uk.sun.com (Tim Jinkerson - Sun UK - Applications Engineer)
> Newsgroups: comp.databases.oracle
> Subject: Re: How to modify an stored procedure ?
> Date: 26 Apr 1996 12:48:19 GMT
> Organization: Sun Microsystems (UK)
> Lines: 32
> Distribution: world
> Message-ID: <4lqgmj$bbg_at_flonk.uk.sun.com>
> References: <317F80C1.6219_at_charlie.acc.iit.edu>
> Reply-To: timj_at_baa.uk.sun.com
> NNTP-Posting-Host: baa.uk.sun.com
>
> 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
>
>
>

this is not to say that the privious answer was worng becouse it's right (it is in fack the complete answer) but for the day-to-day perpose use the oracle procedural builder (a part of the developer2000 kit) to handle pl/sql code. look this tool up. it's a GUI tool and that says it all.

p.s.
for now it support only pl/sql version 1 , does it change anything ?

b.t.w.

        designer2000 users can use the module-logic-navigator inside it as another pl/sql writting environment Received on Sun Apr 28 1996 - 00:00:00 CEST