/db-migrate/templates/templates/ddl.sql

 1
 2VARIABLE v_pk  NUMBER;
 3
 4BEGIN
 5    ${schema}.sp_log_version_change_begin('${script_name}', &1, :v_pk);
 6END;
 7/
 8
 9---- ddl below ------------------------------------------
10
11---------------------------------------------------------
12
13BEGIN
14    ${schema}.sp_update_version(${version_no});
15    ${schema}.sp_log_version_change_finish(:v_pk, 'success');
16EXCEPTION
17    WHEN OTHERS THEN
18        ${schema}.sp_log_version_change_finish(:v_pk, 'fail');
19END;
20/