[GENERAL] passing parameters to a trigger function

2006-03-21 Thread Larry White
I can't figure out how to pass parameters to a trigger function. I checked the documentation and saw that trigger functions don't take params in the usual fashion, but couldn't find an example of a pl-sql trigger function that used the original row data within the function. What I want is an on

Re: [GENERAL] passing parameters to a trigger function

2006-03-21 Thread Terry Lee Tucker
On Tuesday 21 March 2006 09:21 am, Larry White saith: I can't figure out how to pass parameters to a trigger function. I checked the documentation and saw that trigger functions don't take params in the usual fashion, but couldn't find an example of a pl-sql trigger function that used the

Re: [GENERAL] passing parameters to a trigger function

2006-03-21 Thread Martijn van Oosterhout
On Tue, Mar 21, 2006 at 09:21:43AM -0500, Larry White wrote: I can't figure out how to pass parameters to a trigger function. I checked the documentation and saw that trigger functions don't take params in the usual fashion, but couldn't find an example of a pl-sql trigger function that used

Re: [GENERAL] passing parameters to a trigger function

2006-03-21 Thread Stephan Szabo
On Tue, 21 Mar 2006, Larry White wrote: I can't figure out how to pass parameters to a trigger function. I checked the documentation and saw that trigger functions don't take params in the usual fashion, but couldn't find an example of a pl-sql trigger function that used the original row

Re: [GENERAL] passing parameters to a trigger function (solved)

2006-03-21 Thread Larry White
Thank you. You guys rock!On 3/21/06, Stephan Szabo [EMAIL PROTECTED] wrote: On Tue, 21 Mar 2006, Larry White wrote: I can't figure out how to pass parameters to a trigger function. I checked the documentation and saw that trigger functions don't take params in the usual fashion, but couldn't find