/hippo-migrate/templates/ddl.sql
SQL | 19 lines | 13 code | 4 blank | 2 comment | 0 complexity | 7ecf41b78f3b7d5b88eb019cbcbfc2f2 MD5 | raw file
1VARIABLE v_pk NUMBER; 2 3BEGIN 4 hippo.sp_log_version_change_begin('${script_name}', &1, :v_pk); 5END; 6/ 7 8---- ddl below ------------------------------------------ 9 10--------------------------------------------------------- 11 12BEGIN 13 hippo.sp_update_version(${version_no}); 14 hippo.sp_log_version_change_finish(:v_pk, 'success'); 15EXCEPTION 16 WHEN OTHERS THEN 17 hippo.sp_log_version_change_finish(:v_pk, 'fail'); 18END; 19/