kurs:for_update_cursor_und_exception_im_block
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
kurs:for_update_cursor_und_exception_im_block [2011/11/23 14:53] mh |
kurs:for_update_cursor_und_exception_im_block [2014/09/10 21:22] 127.0.0.1 external edit |
||
|---|---|---|---|
| Line 63: | Line 63: | ||
| BEGIN | BEGIN | ||
| - | |||
| - | open c_set_emp_bonus; | ||
| - | |||
| for i in 1..3 loop | for i in 1..3 loop | ||
| begin | begin | ||
| + | if not c_set_emp_bonus%isopen then | ||
| + | open c_set_emp_bonus; | ||
| + | end if; | ||
| loop | loop | ||
| fetch c_set_emp_bonus into r; | fetch c_set_emp_bonus into r; | ||
| Line 83: | Line 83: | ||
| end loop; | end loop; | ||
| - | close c_set_emp_bonus; | + | if c_set_emp_bonus%isopen then |
| + | close c_set_emp_bonus; | ||
| + | end if; | ||
| dbms_output.put_line(v_worked); | dbms_output.put_line(v_worked); | ||
| END; -- Procedure | END; -- Procedure | ||
| </code> | </code> | ||
kurs/for_update_cursor_und_exception_im_block.txt · Last modified: 2014/11/11 12:35 by mh
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
