Re: Why my package change aren't taken in count

"Jérôme VUIBERT" wrote:

> Hi.
>
> Here is my problem.
>
> I have a package with its procedures and functions.
>
> When I change the body of a procedure for instance, I have to disconnect and
> reconnect in order the changes to be taken in count even if :
> - i commit the changes
> - i compile the body of the package
> before disconnecting.
>
> I use Oracle 9i R2.
>
> So can someone help me.
>
> Thanks a lot.
>
> jerome

Go to http://tahiti.oracle.com and look up dbms_session.reset_package.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)