Oracle Application Express (MOSC)

MOSC Banner

Strange problem - automatic PK generation doesnt work (Apex)

edited Jun 19, 2019 2:32AM in Oracle Application Express (MOSC) 5 commentsAnswered ✓

Hi all,

first of all i want to apologize for the meaningless title but i cant describe it better in a few words.

I haven't really developed since Apex 3.x and now want to build a small application, unfortunately I have a strange problem that I can't explain to myself. Probably it's totally self-explanatory and I just don't see the solution.

I read, that i dont have to bother with sequence and triggers anymore for PK, so i created the PK column like this:

"C_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOT NULL ENABLE

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