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

/hippo-migrate/undo/00013-undo_ModifyExperiments.sql

http://hdbc.googlecode.com/
SQL | 19 lines | 14 code | 3 blank | 2 comment | 0 complexity | aef1cb8d0f1d4969644650ea2d898840 MD5 | raw file
 1VARIABLE v_pk  NUMBER;
 2
 3BEGIN
 4    hippo.sp_log_version_change_begin('00013-do_ModifyExperiments.sql', &1, :v_pk);
 5END;
 6/
 7
 8---- ddl below ------------------------------------------
 9ALTER TABLE hippo.experiments drop (modified_dt, modified_by, concluded);
10---------------------------------------------------------
11
12BEGIN
13    hippo.sp_update_version(12);
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/