BEGIN
tmpVar := 0;
SELECT USER_SEQ.NEXTVAL INTO tmpVar FROM dual;
:NEW.C_ID := tmpVar;
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END USER_Triggers;
/
BEGIN
tmpVar := 0;
SELECT USER_SEQ.NEXTVAL INTO tmpVar FROM dual;
:NEW.C_ID := tmpVar;
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END USER_Triggers;
/