Re: Oracle triggers

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 24 Jul 2002 17:40:58 GMT
Message-ID: <3D3EE666.19FA0BB5@exesolutions.com>

Chuck wrote:

> I am looking for some help with developing an Oracle trigger.
> The trigger has to look at users and only allow them to select certain
> values based on their security. There are two tables involved. When I
> try nested if statements in the trigger, it ignores anything after the
> first if statement or ignores certain users embedded in the trigger.
>
> Any ideas?

Many ... but most involve information you have not provided.

Look at:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_rl2.htm#1000740

Daniel Morgan Received on Wed Jul 24 2002 - 12:40:58 CDT