Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing a stored procedure in a package (newbie)
hpuxrac wrote:
> google_at_easiesttoremember.com wrote:
> > I'm new to Oracle, but not to databases. I've got a package with many
> > stored procedures in it. Is it possible to change just one stored
> > procedure without having to resubmit a script with absolutely
> > everything in the package also in the script?
> >
> > If the answer is that we have to resubmit a script with the entire
> > package contents, then is there a way to retrieve a current snapshot
> > script from the database, assuming that no one kept up with or someone
> > lost or messed up said script?
> >
> > TIA
>
>
> Yes you can retrieve the code from the database. To change a procedure
> inside a package you need to work with the package body aka "almost the
> whole package".
Appreciated. Received on Tue Aug 29 2006 - 16:40:19 CDT