Re: Passing parameter(data) to trigger

you can use package sesson variables, by setting an appropriate value in the fuction foo.

/Kel

jeanch_at_my-deja.com wrote:

> folks,
>
> I don't know if this is doable; I am looking for a way
> of passing data to a trigger so the trigger could use it in its logic;
>
> ...
> foo(x in integer)
>
> begin
> ...
> insert into tab values(y,z);
> /* in a trigger fired off at insert into tab
> we want to use x value to do some processing */
> end;
>
> Any thoughts on this
> Cheers
> JC
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Feb 22 2000 - 01:13:12 CST