aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_delete_mealtype_json
Parameters
Name
Type
Mode
p_mealtype_id
integer
IN
Definition
declare v_result json; v_msg_text text; v_sqlstate text; v_detail text; v_hint text; v_context text; begin delete from meal_type where id = p_mealtype_id; return fn_result_success(); exception when others then get stacked diagnostics v_msg_text = message_text, v_sqlstate = returned_sqlstate, v_detail = pg_exception_detail, v_hint = pg_exception_hint, v_context = pg_exception_context; if v_sqlstate = '23503' then v_msg_text := sys_msg('81001', 'Cannot delete, record in-use'); end if; return fn_handle_error( v_sqlstate, v_msg_text, v_detail, v_hint, v_context, 'sp_delete_mealtype_json', null ); END;