PageRenderTime 7ms CodeModel.GetById 1ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

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

http://hdbc.googlecode.com/
SQL | 20 lines | 13 code | 5 blank | 2 comment | 0 complexity | f5cc072fd0f5284592166da499cbcb35 MD5 | raw file
 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/