/hippo-migrate/do/00008-do_CreateExperiments.sql

 1VARIABLE v_pk  NUMBER;
 2
 3BEGIN
 4    hippo.sp_log_version_change_begin('00008-do_CreateExperiments.sql', &1, :v_pk);
 5END;
 6/
 7
 8---- ddl below ------------------------------------------
 9CREATE TABLE hippo.experiments(
10	experiment_cd 		number CONSTRAINT pk_experiments PRIMARY KEY,
11	type 				varchar2(16 char),
12	title				varchar2(64 char) NOT NULL,
13	purpose				varchar2(128 char) NOT NULL,
14	method				varchar2(4000 char),
15	conclusion			varchar2(4000 char)
16);
17---------------------------------------------------------
18
19BEGIN
20    hippo.sp_update_version(8);
21    hippo.sp_log_version_change_finish(:v_pk, 'success');
22EXCEPTION
23    WHEN OTHERS THEN
24        hippo.sp_log_version_change_finish(:v_pk, 'fail');
25END;
26/