ORA-00922: missing or invalid option
505004Apr 7 2006 — edited Apr 7 2006Hello, i'm getting the error "ORA-00922: missing or invalid option" when I try to run my script. I'm fairly new to Oracle (used SQLserver before), so any help would be greatly appreciated. Also any resources you can point me to.
Thank you
/*CREATES RVSN_CHK_SECTION TABLE*/
CREATE OR REPLACE TABLE RVSN_CHK_SECTION (
SECTION_ID number,
SECTION_TEXT varchar2(50),
SECTION_ORDER number,
UPDATE_USER_ID number,
TIMESTAMP date,
CONSTRAINT PK_SECTION_ID PRIMARY KEY (SECTION_ID),
CONSTRAINT SECTION_ORDER_UNIQUE UNIQUE (SECTION_ORDER));
/
/*CREATES RVSN_CHK_SECTION SEQUENCE*/
CREATE SEQUENCE RVSN_CHK_SECTION_SEQ
START WITH 1
INCREMENT BY 1
NOMAXVALUE;
/
/*CREATES RVSN_CHK_SECTION TRIGGER*/
CREATE OR REPLACE TRIGGER ACTUARY.RVSN_CHK_SECTION_TRG
BEFORE INSERT
ON ACTUARY.RVSN_CHK_SECTION
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
IF :NEW.SECTION_ID IS NULL THEN
SELECT RVSN_CHK_SECTION_SEQ.NEXTVAL INTO :NEW.SECTION_ID
FROM DUAL;
END IF;
END ;
/
/*CREATES TIMESTAMP TRIGGER*/
CREATE OR REPLACE TRIGGER ACTUARY.RVSN_CHK_SECTION_TIMESTAMP_TRG
BEFORE INSERT OR UPDATE
ON ACTUARY.RVSN_CHK_SECTION
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
SELECT SYSDATE INTO :NEW.TIMESTAMP FROM DUAL;
END ;
/