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

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