ThomasJaspers/robotframework-dblibrary — Issue #7: Can not create Trigger
Author: ThomasJaspers
Created: 2012-01-27 12:55:22+00:00
State: open

All this instructions are in the same file and called by the Keyword
"Execute SQL From File"

1. Creating the Table TEST_TABLE works:
CREATE TABLE TEST_TABLE
(
ID number,
NAME VARCHAR2(255),
PRIMARY KEY (ID)
);

2.Creating the sequence works:
create sequence TEST_TABLE_SEQ start with 1 increment by 1 nomaxvalue;

3. Creating a trigger does not work:
create trigger TEST_TABLE_TRIGGER
before insert on TEST_TABLE
for each row
begin
select TEST_TABLE_SEQ.nextval into :new.ID from dual;
end;

May be the problem is on the semicolon at position "..new.ID from dual;"