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)
Andy Hassall wrote:
> 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.
Perfect! Thanks! Received on Tue Aug 29 2006 - 16:38:59 CDT
![]() |
![]() |