PageRenderTime 16ms CodeModel.GetById 13ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/hippo-migrate/templates/ddl.sql

http://hdbc.googlecode.com/
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/