Database Administration (MOSC)

MOSC Banner

Sequence dont exist but I can see it! What have I missed?

edited Jan 15, 2012 7:00PM in Database Administration (MOSC) 2 commentsAnswered ✓
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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center