Re: FRM 40508 Oracle error

Hi, all,

I encounter the same problem now. I have a form which has one master blk and three detail blks. Whenever i try to insert a record to database, FRM40508 error always occurs. I am very confused. It is supposed to work, but it can't.

And in my opinion if there is an unique constraint, another error should occurs, not FRM40508.
Could somebody give idea about it?

Regards

Mike
fding_at_idirect.com

In article <7gl6b2$okh$1_at_nnrp1.dejanews.com>,   analyst_user_at_my-dejanews.com wrote:
> 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 ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 01:04:49 CEST