FRM 40508 Oracle error

From: <>
Date: Mon, 03 May 1999 22:01:08 GMT
Message-ID: <7gl6b2$okh$>

[Quoted] I have a form that has a block based on a table. This block contains a field which is used to find matches within that table, for example the same last name.

If there aren't any records found that match the last name and if I do a commit, the record gets inserted 2x. If there is a match then I receive the FRM 40508 error when trying to insert.

The table does not have any unique indexes. All fields that are required are populated. When I try inserting the same information manually in SQL Plus the record is inserted without a problem.

Any ideas on what might be wrong?

-----------== Posted via Deja News, The Discussion Network ==---------- Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 00:01:08 CEST

Original text of this message