Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> cursor/update freezes
Hi
i use the following cursor/update methode but the system freezes while running the program in wich this sql is embedded. Does anybody have an idea why????
Thanks
EXEC SQL WHENEVER NOT FOUND DO break;
EXEC SQL DECLARE emp_cursor CURSOR FOR SELECT AMOUNT FROM SYS.BP_DECO WHERE
DEALER_ID = :searchkey FOR UPDATE OF AMOUNT;
EXEC SQL OPEN emp_cursor;
for(;;) {
EXEC SQL FETCH emp_cursor INTO :mamount; EXEC SQL UPDATE SYS.BP_DECO SET AMOUNT = 10 WHERE CURRENT OF emp_cursor; }
![]() |
![]() |