tag:blogger.com,1999:blog-497787815177352569.post4071692484798233021..comments2024-01-03T08:55:04.827-05:00Comments on SQL Anywhere: Dump and ContinueBreck Carterhttp://www.blogger.com/profile/15975598564711761434noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-497787815177352569.post-15541982294462330262012-03-27T10:48:22.950-04:002012-03-27T10:48:22.950-04:00Hi,
Thanks for your example, but I have question:
...Hi,<br />Thanks for your example, but I have question:<br />How I do 'commit' in try...catch... block?<br /><br />I have code as bellow:<br /><br />for a as aa dynamic scroll cursor for<br />select a from tabl<br />do <br />begin<br />call some_proc(a); -- in proc I Have commit and it must be there<br />EXCEPTION WHEN OTHERS THEN<br /> SELECT SQLCODE, SQLSTATE, ERRORMSG()<br /> INTO @sqlcode, @sqlstate, @errormsg;<br />END;<br />end for;keroghttps://www.blogger.com/profile/15977418327230487803noreply@blogger.com