/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. CREATE OR REPLACE PROCEDURE ${schema}.sp_log_version_change_finish

    2. 

  2. (

    3. 

  3.     p_pk IN NUMBER,

    4. 

  4.     p_status IN VARCHAR2

    5. 

  5. ) AS

    6. 

  6. BEGIN

    7. 

  7.     UPDATE version_change_log

    8. 

  8.         SET status = p_status

    9. 

  9.         WHERE version_change_log_id = p_pk;

    10. 

  10.     COMMIT;

    11. 

  11. END;

    12. 

  12. /

    13. 

  13. 

    14. 

  14. UPDATE ${schema}.version SET version = 6;

    15. 

  15. COMMIT;
    16.