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: Erik <ecotsonas_at_saraswati.com>
Date: Tue, 14 Dec 1999 19:47:26 GMT
Message-ID: <8366sc$imp$1@nnrp1.deja.com>


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 - 13:47:26 CST

Original text of this message

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