sponsored links

oraccle produdure 异常处理

oracle procdure loop 内异常后继续下一次循环

May 21
oracle  procdure  loop 内异常后继续下一次循环
1)oracle  procdure 内异常处理 for num in 1..total loop begin strsql := 'select ssid from (select temp.sp_id as ssid, rownum as ssnum                 from tempInfo temp) where ssnum='|| num;          execute immediate strsql into tempspid; strsql := 'updat