试:
DECLARE dbmx_cursor CURSOR SCROLL_LOCKS FOR SELECT djbh,spid,recnum FROM dbmx order by djbh for update
DECLARE dbmx_cursor CURSOR SCROLL_LOCKS FOR SELECT djbh,spid,recnum FROM dbmx order by djbh for update
... FOR UPDATE OF dj_sn
游标声明改如下:
DECLARE dbmx_cursor CURSOR SCROLL_LOCKS
FOR SELECT djbh,spid,recnum FROM dbmx order by djbh for update of dj_sn
但还提示read only