I get the following error when I execute my Insert Trigger:
commit/rollback not allowed within atomic operation trigger stored procedure
The trigger appears to be the problem because if I comment out the last line of the trigger it works. The stored procedure is much more complex but it runs successfully if I harcode the parameter value in. Can someone shed some light on this one please?
This is the trigger:
Code:
DBA.vinTrigger
for each row /* REFERENCING NEW AS new_name */
/* WHEN( search_condition ) */
begin
declare @datapath varchar(200);
set @datapath=(select datapath from vinTrigger where ID = (select MAX(ID) from vinTrigger));
call VINImport(@datapath)
end
|
