Re: PL/SQL Update doesn't give correct values

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Fri, 24 Sep 1999 14:48:44 -0400
Message-ID: <Q8frNyrW1CrWBCmubx2K+i4pvf9Q@4ax.com>

On Fri, 24 Sep 1999 18:22:18 GMT, sxbktm_at_my-deja.com wrote:

>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.

Post you code and we should be able to debug it.

chris.

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

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Sep 24 1999 - 13:48:44 CDT