aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_delete_calendar
Parameters
Name
Type
Mode
p_id
integer
IN
Definition
DECLARE v_state text; v_message text; v_detail text; v_hint text; v_context text; BEGIN DELETE FROM public.calendar WHERE id = p_id; -- events/sources cascade RETURN fn_result_success(); EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS v_state = RETURNED_SQLSTATE, v_message = MESSAGE_TEXT, v_detail = PG_EXCEPTION_DETAIL, v_hint = PG_EXCEPTION_HINT, v_context = PG_EXCEPTION_CONTEXT; IF v_state = '23503' THEN v_message := sys_msg('81001', 'Cannot delete, record in-use'); RETURN fn_result_error('81001', v_message); END IF; RETURN fn_handle_error(v_state, v_message, v_detail, v_hint, v_context, 'public.sp_delete_calendar', null::jsonb); END