oracle11g - Stored procedure with mulitple queries in ORACLE -
i have stored procedure named edit_emp
inside stored procedure have 10 update queries.
now error in 5th update statement - happen rest of update query? terminate in 5th update line or execute rest of update queries?
exception when others then
// dbms_output.put_line ('error');
continue
;
just add exception handler in ur procedure
Comments
Post a Comment