Trigger calling StoredProcedure

Database

Trigger calling StoredProcedure

Hi There,

when i am trying to call a stored proc through triggers i am getting an error message :

ERROR [42000] [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

 WHEN  

 ((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!

3 REPLIES

Re: Trigger calling StoredProcedure

I AM FACING SAME PROBLEM. CAN ANY PLZ TELL ME SOLUTION........................

Re: Trigger calling StoredProcedure

Teradata supports the CALL statement as a triggered action statement only in AFTER triggers.  

Re: Trigger calling StoredProcedure

Does it hold true in TD 14.10 also?

Thanks and regards,

Raja