Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL update doesn't give right values
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
![]() |
![]() |