Sequence dont exist but I can see it! What have I missed?
Im trying to use a sequnce which shall fire on a insert to my table. But I get an error.
The table
CREATE TABLE storelog.Store_log_events (
id number not null,
store varchar(50) NULL,
register varchar(50) NULL,
operator varchar(50) NULL,
datetime varchar(50) NULL,
eventname varchar(50) NULL,
eventinfo varchar(250) NULL);
ALTER TABLE storelog.Store_log_events ADD (
CONSTRAINT pk_id PRIMARY KEY (ID));
The sequence
CREATE SEQUENCE storelog.LDX_id_SEQ
START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER;
The trigger
CREATE OR REPLACE TRIGGER storelog.ldx_id_trigger
before insert ON storelog.Store_log_events for each row
begin
select storelog.ldx_id_seq.nextval into :new.id from dual;
The table
CREATE TABLE storelog.Store_log_events (
id number not null,
store varchar(50) NULL,
register varchar(50) NULL,
operator varchar(50) NULL,
datetime varchar(50) NULL,
eventname varchar(50) NULL,
eventinfo varchar(250) NULL);
ALTER TABLE storelog.Store_log_events ADD (
CONSTRAINT pk_id PRIMARY KEY (ID));
The sequence
CREATE SEQUENCE storelog.LDX_id_SEQ
START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
NOCACHE
NOORDER;
The trigger
CREATE OR REPLACE TRIGGER storelog.ldx_id_trigger
before insert ON storelog.Store_log_events for each row
begin
select storelog.ldx_id_seq.nextval into :new.id from dual;
0