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

Changing a stored procedure in a package (newbie)

From: <google_at_easiesttoremember.com>
Date: 29 Aug 2006 13:05:07 -0700
Message-ID: <1156881907.613968.254690@p79g2000cwp.googlegroups.com>


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 Received on Tue Aug 29 2006 - 15:05:07 CDT

Original text of this message

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