Before Insert trigger conflict

[Quoted] version: Forms 6.0.8.1.9.2

         Oracle 8.1.7.3
         Windows 2000

Our database has some tables where the Primary Key is generated through a
sequence and inserted with a BEFORE INSERT trigger.

My developers are telling me now that when they insert through a form that this
trigger is not functioning correctly, that they're getting a "duplicate value on
primary key" error. They say we have to disable the triggers in the database and
insert the PK value through a forms trigger.

The problem is that inserts to the database will not occur only through the forms interface so obviously, without the database trigger, the PK value will not be inserted. According to one of them, this is a standard forms problem, but I find that hard to believe.

Any thoughts are much appreciated and thank you in advance,

Steve Received on Wed Jun 25 2003 - 14:53:14 CEST