/hippo-migrate/templates/ddl.sql

http://hdbc.googlecode.com/ · SQL · 19 lines · 13 code · 4 blank · 2 comment · 0 complexity · 7ecf41b78f3b7d5b88eb019cbcbfc2f2 MD5 · raw file 

    

  1. VARIABLE v_pk  NUMBER;

    2. 

  2. 

    3. 

  3. BEGIN

    4. 

  4.     hippo.sp_log_version_change_begin('${script_name}', &1, :v_pk);

    5. 

  5. END;

    6. 

  6. /

    7. 

  7. 

    8. 

  8. ---- ddl below ------------------------------------------

    9. 

  9. 

    10. 

  10. ---------------------------------------------------------

    11. 

  11. 

    12. 

  12. BEGIN

    13. 

  13.     hippo.sp_update_version(${version_no});

    14. 

  14.     hippo.sp_log_version_change_finish(:v_pk, 'success');

    15. 

  15. EXCEPTION

    16. 

  16.     WHEN OTHERS THEN

    17. 

  17.         hippo.sp_log_version_change_finish(:v_pk, 'fail');

    18. 

  18. END;

    19. 

  19. /
    20.