Hi,
I have a table NP_COMPANY with a primary key ID and some other value. I try to put a modal form to enter new values into the table using the modal form. The problem was that when I tried to enter new values I got a message: “You can enter NULL into ”NP_COMPANY"."ID"". I tried to make a sequence seq_company
CREATE SEQUENCE "seq_company" MINVALUE 153603 MAXVALUE 1000000 INCREMENT BY 1 START WITH 153623 CACHE 20;
and reference it in the ID field in the default section, but then I got an error: ORA-00001 unique constraints were violated (SWPZAPEX.SYS_C0088288). It appears to be an index called SYS_C0088288 on the NP_COMPANY table. It was created by someone else with a code:
CREATE UNIQUE INDEX "SYS_C0088288" ON "NP_COMPANY" ("ID") ;
I tried to use this index as a sequence instead of mine sequence and then I got an error: ORA-06550: line 1, column 44: PLS-00201: identifier "SYS_C0088288.NEXTVAL" should be declared. Is there a way for me to somehow use this index for my primary key field?
Thank you