Problems in calling stored procedure from trigger... [message #37981] |
Tue, 12 March 2002 06:03 |
raman
Messages: 66 Registered: February 2000
|
Member |
|
|
Hi,
I have a trigger written on a table T1. This trigger calls a a stored procedure SP1. This procedure SP1 insert some rows in table T2, T3 and T4. Before having this trigger, SP1 had commit at the end and rollback in the exception section. Now after writing the trigger, I removed the commit and rollback from SP1. Now when I execute the trigger, the values are not inserted in T2, T3 and T4.
How can I make that happen ??
|
|
|
|