|
|
Archives of the TeradataForum
Message Posted: Fri, 11 Aug 2006 @ 14:16:59 GMT
Subj: | | Re: Execute a stored procedure from a trigger |
|
From: | | Victor Sokovin |
| I urgently need information if is it actually possible in Teradata to invoke a stored procedure from a trigger. SQL Reference for 2.5.x
(dated November, 2002) says it is not supported, but several articles in Teradata Magazine mentioned that such functionality is available. If it
is supported, then on what release? Highly appreciated!!! | |
V2R6.0 seems to allow stored procedures with some restrictions on statements in them. The restrictions are rather complex and relate to the way
all transactions involved should be handled.
Please refer to the SQL Reference manual, section Data Definition Language.
If you decide to do something practical with this I would suggest to allow plenty of time for testing. Surprises are always possible with
triggers of any kind.
Regards,
Victor
| |