hello,
i have created a sequence in my table in jdeveloper i have same error as this
http://stackoverflow.com/questions/27134487/how-to-use-adf-createinsert-when-having-a-sequence-generated-id-trigger-in-my-da[
^]
i tried solving this but i have no error and no updated table. my sql query is somewaht like this
CREATE TABLE "SYSTEM"."REGISTRATION"
(
"USERID" NUMBER NOT NULL ENABLE,
"USERNAME" VARCHAR2(20 BYTE),
"PASSWORD" VARCHAR2(20 BYTE),
"STATE_ID" NUMBER,
"CITY_ID" NUMBER,
"DATE_OF_BIRTH" DATE,
"EMAIL" VARCHAR2(20 BYTE),
"TELEPHONE_NO" NUMBER,
CONSTRAINT "REGISTRATION_PK" PRIMARY KEY ("USERID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" ENABLE
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE "SYSTEM" ;
CREATE OR REPLACE TRIGGER "SYSTEM"."REG_TRIGGER" before
INSERT ON "SYSTEM"."REGISTRATION" FOR EACH row BEGIN IF inserting THEN IF :NEW."USERID" IS NULL THEN
SELECT REG_SEQUENCE.nextval INTO :NEW."USERID" FROM dual;
END IF;
END IF;
END;
/
ALTER TRIGGER "SYSTEM"."REG_TRIGGER" ENABLE;