FRM 30100
423853Dec 17 2004 — edited Dec 2 2008Hi,
I am using forms 9i (9.0.2.9.0) and using oracle 9i database (Oracle9i Enterprise Edition Release 9.2.0.4.0). I am getting the FRM - 30100 error while compiling when I have a block with no primary key. I looked up the online help which said
"Cause: At least one item should be marked as being part of the primary key if one of the following is true: 1. The key mode for the block is either UPDATEABLE_PRIMARY_KEY or NON_UPDATEABLE_PRIMARY_KEY. 2. The key mode for the block is AUTOMATIC but the data source to which you are connected does not support UNIQUE key mode. "
My block is based on a single table, the enforce primary key is NO, the locking mode is Automatic and the Key mode is Automatic. I do not understand why it is necessary to have a primary key item. Doesn't Oracle support the Unique key mode??
Thanks,
Monica