Re: Passing a parm to a trigger

Use a variable in a package, on package level. You can assign to it and use it, wherever you want.

Hth,

Sybrand Bakker, Oracle DBA

"Terry Young" <terry.young_at_wright.edu> wrote in message news:3960F96D.85BD8290_at_wright.edu...
> Would anyone have an idea about how to capture a parm and
> send it to a trigger?
>
> For example we have an application that logs into an Oracle
> account with a specific user account then using role
> enabling and role checking logs into a generic oracle
> account set up specifically for that application, then
> disconnects from the user account.
>
> The problem is when you have an update to a table, the same
> account is doing the update in the trigger, no way to
> identify who is doing the updating.
>
> Is there any way of doing this and still do the account
> switching.
Received on Mon Jul 03 2000 - 00:00:00 CDT