1BEGIN
2   EXECUTE IMMEDIATE 'DROP TABLE velocity_template_varchar';
3EXCEPTION
4   WHEN OTHERS THEN
5      IF SQLCODE != -942 THEN
6         RAISE;
7      END IF;
8END;
9
10create table velocity_template_varchar
11(
12	vt_id VARCHAR(64) not null,
13	vt_timestamp TIMESTAMP,
14	vt_def VARCHAR(255) not null
15);
16
17insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
18	( 'testTemplate1', current_timestamp, 'I am a test through the data loader');
19
20insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
21	( 'testTemplate2', current_timestamp, '$tool.message $tool.add(23, 19)');
22
23insert into velocity_template_varchar (vt_id, vt_def) VALUES
24	( 'testTemplate3', 'This is a template with a null timestamp');
25
26insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
27	( 'testTemplate4', current_timestamp, '#testMacro("foo")');
28
29insert into velocity_template_varchar (vt_id, vt_timestamp, vt_def) VALUES
30	( 'VM_global_library.vm', current_timestamp, '#macro (testMacro $param) I am a macro using $param #end');
31
32
33-- same templates as clob
34
35BEGIN
36   EXECUTE IMMEDIATE 'DROP TABLE velocity_template_clob';
37EXCEPTION
38   WHEN OTHERS THEN
39      IF SQLCODE != -942 THEN
40         RAISE;
41      END IF;
42END;
43
44create table velocity_template_clob
45(
46	vt_id VARCHAR(64) not null primary key,
47	vt_timestamp TIMESTAMP,
48	vt_def CLOB not null
49);
50
51insert into velocity_template_clob select * from velocity_template_varchar;
52