Re: CALL In Trigger
Hi, Tim!
Tim Shor wrote:
> Will the regular sql statements (SELECT ... FROM ... WHERE ...)
> be supproted in the triggers as well?
Yes they will. Of course you won't be able to use in trigger statement
which directly returns result to the client (like simple SELECT), but it
will be perfectly OK to work with SELECT via cursor or use SELECTs
which store their result in variables.
And as I've already said in another thread on this forum we plan to allow
access to other tables from triggers in 5.0 branch. So probably you will be
able test this feature in nearest couple of months.
Hope this helps!
Dmitri Lenev, Software Developer
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
5421
March 10, 2005 02:22PM
2873
March 11, 2005 02:29AM
2559
March 11, 2005 03:50PM
2729
May 06, 2005 03:38AM
2701
May 24, 2005 10:35AM
Re: CALL In Trigger
2741
May 25, 2005 11:54AM
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.