All Forums Database
n_kiranmai8 2 posts Joined 09/11
01 Sep 2011
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!

 

jagadeesha6 1 post Joined 09/11
07 Sep 2011

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

jagadeesh

Jim Chapman 449 posts Joined 09/04
07 Sep 2011

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

Raja_KT 1246 posts Joined 07/09
03 Nov 2013

Does it hold true in TD 14.10 also?
Thanks and regards,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.