Home » Developer & Programmer » Designer » After generating table API and insert data get trigger failure on first insert
After generating table API and insert data get trigger failure on first insert [message #159967] Wed, 22 February 2006 08:13
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member
Hi,

I've noticed with Designer that after generating table API, the first insert into certain tables results in a trigger failure of some strange kind. Insert again and it's ok. The problem is that I'm developing an application to be deployed to customers via scripts and can't afford to have this kind of trigger failure occurring as it will mess up the data. It doesn't help that it appears to be inconsistent. This was happening with Oracle 9i, and now I'm using 10g.

Can anyone tell me what's going on with this, and how I can ensure my customers don't receive this particular type of problem? I have to make deployment automatic, especially as they may not have detailed oracle knowledge.

Thanks
Adam
Previous Topic: Error When Capture Design Of Reports
Next Topic: Prompting the end user for a selection
Goto Forum:
  


Current Time: Thu Mar 28 16:03:32 CDT 2024