PageRenderTime 17ms CodeModel.GetById 14ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

http://hdbc.googlecode.com/
SQL | 16 lines | 14 code | 2 blank | 0 comment | 0 complexity | 193621494ec3610042bbf6ac9168b9fd MD5 | raw file
 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;