Re: Sql Loader + Trigger
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 5 Aug 1998 21:16:13 +0200
Message-ID: <6qab11$sdo$1_at_pascal.a2000.nl>
Date: Wed, 5 Aug 1998 21:16:13 +0200
Message-ID: <6qab11$sdo$1_at_pascal.a2000.nl>
Give us some more info! Show us your trigger. Maybe you made an *after* insert trigger? Are you sure that it only deletes the row that has the same product id? If it deletes all the rows having a certain date, then it will also delete the rows which have been inserted a few moments ago, having the same date:
004 0 07/06/98
005 1 07/06/98
006 2 07/06/98
007 3 07/06/98
008 4 07/06/98
Only the last row will be left!
Or, if your trigger also takes the product id into account, are you sure that your input file has only one row per product id? Tell us more.
Arjan. Received on Wed Aug 05 1998 - 21:16:13 CEST