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: Changing a stored procedure in a package (newbie)

Re: Changing a stored procedure in a package (newbie)

From: <google_at_easiesttoremember.com>
Date: 29 Aug 2006 14:40:19 -0700
Message-ID: <1156887619.043489.104680@m73g2000cwd.googlegroups.com>


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

Original text of this message

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