By having no source you probably mean that the package is wrapped with
WRAP utility. Well, bad news in this case: there is no way you can extend
the package in place.
A workaround: you can write a wrapper package that has all of the old
procedures and functions declared in its interface plus your additions. Old
procs will just pass the parameters to the old package and new procs will do
what you need. You will have to give this wrapper package a new name (or
rename the old one - this is fairly easy even with wrapped packages because
they still have their name in CREATE OR REPLACE thus you can change the
name and create a copy of the package).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Marco" <Marco_at_hotmail.com> wrote in message news:2002218-181031-572683_at_foorum.com...
>
> Hello,
>
> What is the way to add a new procedure to an existing package (from which I
> haven't got the source otherwise I would have used
> "CREATE OR REPLACE PACKAGE BODY "...)
>
> Thanks in advance.
>
>
> --
> Use our news server 'news.foorum.com' from anywhere.
> More details at: http://nnrpinfo.go.foorum.com/
Received on Mon Feb 18 2002 - 13:58:55 CST
