TRIGGER (AFTER INSERT) and Store Procedure ... insert failed !

From: Herve MAILLARD (rvkeops-nospam-_at_hotmail.com)
Date: 09/06/04 

Date: Mon, 6 Sep 2004 16:30:46 +0200

Hi,

I have a trigger on a table "CR_OF". :
CREATE TRIGGER Manage_hist ON dbo.cr_of AFTER INSERT AS
EXEC Manage_Data

If my SP is empty (juste keep DECLARE instructions) I have no problem to
insert records in my table.

The problem is that if I remove the comments in my SP then the insert failed
every time...
I really don't understand why ?
I have tested my SP in debug mode and it works well.
Also, my trigger is "after inster" so the data should be already in the
table. No ? Even if I've got something wrong in my SP, how can it failed the
insert who has been alrerady done...

Thanks for your help....I have to install my application in 2 days, and I
really don't know how to solve this probem.

In my SP I use : cursors, update and insert sql instructions.

Herve MAILLARD

Relevant Pages

  • Re: TRIGGER (AFTER INSERT) and Store Procedure ... insert failed !
    ... What the SP you calling from the trigger does? ... > If my SP is empty (juste keep DECLARE instructions) I have no problem to> insert records in my table. ...
    (microsoft.public.sqlserver.programming)
  • Re: Calculate Statistics after insert in a trigger
    ... In case you are on 10G with the automatic stats collection enabled you can ... The optimizer, believing the table empty, produce an access plan that ... CREATE OR REPLACE TRIGGER TABLE_STAT ... but at this time the statistics are not correct because the commit is ...
    (comp.databases.oracle.server)
  • Re: Glock goes off at airport baggage counter
    ... # This retired cop intentionally pulled the trigger on his "empty" Glock, ... Nobody was injured. ...
    (rec.guns)
  • Re: Glock goes off at airport baggage counter
    ... # This retired cop intentionally pulled the trigger on his "empty" Glock, ... Nobody was injured. ...
    (rec.guns)
  • Re: triggering issue with DAQ Assistant
    ... arrays is empty, and an empty array is an invalid input somewhere in your ... run your application in highlight execution mode while looking at the ... This error might also occur if you do not receive a trigger within 10 seconds because ... your DAQmx read will return an empty array.  ...
    (comp.lang.labview)
Loading