aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_save_batch_report_options
Parameters
Name
Type
Mode
batch_item_id
integer
IN
option_values
jsonb
IN
Definition
declare _sqlstate TEXT; _detail TEXT; _hint TEXT; _context TEXT; _msg_text TEXT; begin PERFORM dblink_exec(fn_conn_authen(), format('update batch_report_items set option_values = %L where item_id = %L', option_values, batch_item_id)) ; RETURN fn_result_success(); EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS _msg_text = MESSAGE_TEXT, _sqlstate = RETURNED_SQLSTATE, _detail = PG_EXCEPTION_DETAIL, _hint = PG_EXCEPTION_HINT, _context = PG_EXCEPTION_CONTEXT; RETURN fn_handle_error(_sqlstate, _msg_text, _detail, _hint, _context, 'sp_save_batch_report_options', jsonb_build_object( 'item_id', register_id, 'option_values', option_values ) ); end