/db-migrate/templates/do/00006-do_sp_log_version_change_finish.sql

 1
 2CREATE OR REPLACE PROCEDURE ${schema}.sp_log_version_change_finish
 3(
 4    p_pk IN NUMBER,
 5    p_status IN VARCHAR2
 6) AS
 7BEGIN
 8    UPDATE version_change_log
 9        SET status = p_status
10        WHERE version_change_log_id = p_pk;
11    COMMIT;
12END;
13/
14
15UPDATE ${schema}.version SET version = 6;
16COMMIT;