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: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 29 Aug 2006 21:33:10 +0100
Message-ID: <g299f292mgl0j4jo4b0mr4memroqcsm4rd@4ax.com>


On 29 Aug 2006 13:05:07 -0700, "google_at_easiesttoremember.com" <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?

 No.

>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?

 select dbms_metadata.get_ddl('PACKAGE', 'PACKAGE NAME HERE') from dual;

 Unless the package was wrapped, in which case you're stuffed.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Received on Tue Aug 29 2006 - 15:33:10 CDT

Original text of this message

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