Re: PL/SQL update doesn't give right values

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Sat, 25 Sep 1999 06:58:20 -0400
Message-ID: <Pi6bSLAijK73Ew+5@ahardy.demon.co.uk>

In article <7sgfeo$fp2$1_at_nnrp1.deja.com>, sxbktm_at_my-deja.com writes
>Hi,
>
>I have written a PL/SQL procedure to update rows in the table based on
>various conditions. Eg, I have two three columns A,B,C. C is empty
>and I want to update the values in C. When I use DBMS_Output to see on
>the screen, I get correct values. But when I update the values(the
>update statement is right after DBMS., I get the value for the first
>row all over again.
>I have committed in the end, too.
>
>Has anybody come across this problem.

No. Show us the code.

Andy
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
Andy Hardy. PGP key available on request

Received on Sat Sep 25 1999 - 05:58:20 CDT