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

Home -> Community -> Usenet -> c.d.o.server -> Re: PACKAGE EXECUTION help

Re: PACKAGE EXECUTION help

From: Richard Cuello <rc370_at_columbia.edu>
Date: Tue, 14 Dec 1999 15:33:23 -0500
Message-ID: <3856A993.18E731CF@columbia.edu>


I did issue a commit. no luck

Zuin

Erik wrote:
>
> Did you issue a COMMIT; in your package.procedure?
>
> Erik
>
> In article <8366cp$i8h$1_at_nnrp1.deja.com>,
> ZC <zuin_chn_at_my-deja.com> wrote:
> > I have a package that has a update and delete procedure. When trying
> to
> > run the package, through a reference, the execution is sucessful.
> When I
> > check the table no changes occured. Are the any suggestions on why the
> > table hasn't changed. There are to integrity constraints on the table.
> >
> > this is what is in the package:
> >
> > UPDATE wpok
> > SET x = 'a_variable'
> > WHERE y = 'b_variable';
> >
> > any suggestions on what is wrong.
> >
> > thanks ZC
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> --
> Erik
> Consultant
> Saraswati Systems Corporation - (SSC)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 14 1999 - 14:33:23 CST

Original text of this message

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