Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why my package change aren't taken in count

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

From: Jérôme VUIBERT <jerome.vuibert_at_fleximage.fr>
Date: Thu, 10 Jul 2003 09:27:49 +0200
Message-ID: <3f0d156e$0$10902$626a54ce@news.free.fr>


Thanks a lot.

Jerome

"Daniel Morgan" <damorgan_at_exxesolutions.com> a écrit dans le message de news: 3F0AEDC9.175D568C_at_exxesolutions.com...
> "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)
>
>
Received on Thu Jul 10 2003 - 02:27:49 CDT

Original text of this message

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