Hi,<br /><br /> If i do update and delete operations on a row pointed by cursor's current then only first operation
succeeds,second operation fails. <br /> Ex. <br /> DROP TABLE IF EXISTS tab; <br /> create table tab (num int,num2 int
);<br /> insert into tab values(1,100); <br /> insert into tab values(2,200); <br /> insert into tab values(3,300); <br
/>insert into tab values(4,400); <br /> insert into tab values(5,500); <br /> insert into tab values(6,600); <br />
insertinto tab values(7,700); <br /> insert into tab values(8,800); <br /> insert into tab values(9,900); <br /> insert
intotab values(10,1000); <br /> BEGIN; <br /> DECLARE c CURSOR FOR SELECT num FROM tab; <br /> FETCH 5 FROM c; <br />
UPDATEtab SET num=500 WHERE CURRENT OF c; <br /> DELETE FROM tab WHERE CURRENT OF c; --> This delete fails. <br />
SELECT* FROM tab; <br /> FETCH 2 FROM c; <br /> COMMIT; <br /> SELECT * FROM tab; <br /> FETCH 2 FROM c;<br /><br /> Is
thisas expected..??<br /><br /> Thanks,<br /> Dharmendra Goyal<br />