MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

calling SP from trigger..how to access the NEW and OLD values
Posted by: Harisankar S
Date: December 03, 2005 04:51AM

Hi,
Can I dynamically referrence a column , inside a trigger.??

I have the column name,which is to be referenced, in a variable.


ie

SET str = 'NEW.name'; //
call spTest(str); // i know this will not work

My intention is to make the value of the column, which is specified in a variable, is available inside the procedure.


Hari

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
calling SP from trigger..how to access the NEW and OLD values
3158
Harisankar S
December 01, 2005 04:44AM
Re: calling SP from trigger..how to access the NEW and OLD values
1984
Roland Bouman
December 01, 2005 04:25PM
calling SP from trigger..how to access the NEW and OLD values
2053
Harisankar S
December 03, 2005 04:51AM
Re: calling SP from trigger..how to access the NEW and OLD values
1933
Harisankar S
December 03, 2005 04:54AM
Re: calling SP from trigger..how to access the NEW and OLD values
2002
Roland Bouman
December 07, 2005 04:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.