| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL update doesn't give right values
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.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 24 1999 - 13:21:28 CDT
 |
 |