when i am trying to call a stored proc through triggers i am getting an error message :
ERROR  [Teradata][ODBC Teradata Driver][Teradata Database] A triggered action statement is the wrong kind.
0 records returned.
CREATE TRIGGER Command Failed.
REPLACE TRIGGER AMPSMIS_DEV.UM_FX_SRVC_START_DT_OVRLP_TRG
BEFORE INSERT ON AMPSMIS_DEV.UM_FX_SRVC_DAY_EXCPT_U ORDER 3
REFERENCING NEW AS NEWROW
FOR EACH ROW
((NEWROW.SWB_PRSN_BETA_ID IS NOT NULL) AND (NEWROW.EXCPT_START_DT IS NOT NULL))
CALL AMPSMIS_DEV.FX_SRVC_EXCPT_START_DT_P(NEWROW.SWB_PRSN_B ETA_ID,NEWROW.EXCPT_START_DT,MSG);
Appreciate if somebody can help me in solving this .
Thanks in advance!