taais/script/sql/postgresql/update_task_and_subtask.sql

DROP PROCEDURE IF EXISTS update_task_and_subtask(bigint,character varying);
CREATE OR REPLACE PROCEDURE update_task_and_subtask(
    p_biz_id BIGINT,
    p_bizType VARCHAR
)
LANGUAGE plpgsql
AS $$
DECLARE
    v_task_id BIGINT;
    v_subtask_id BIGINT;
BEGIN
    -- 根据业务ID和业务类型获取任务ID
EXCEPTION
    WHEN OTHERS THEN
        RAISE EXCEPTION 'Error occurred: % (%). Please check the input and database state.', SQLERRM, SQLSTATE;
END;
$$;