PL/SQL (MOSC)

MOSC Banner

Trigger update

edited Apr 23, 2009 1:58AM in PL/SQL (MOSC) 2 commentsAnswered
 Hi,
I have a trigger as follows,

If :new.column1
then select * from table1

Now i want to include one more column in If condition

that is

If :new.column1 and :new.column2
then select * from table2

It fails erroring at :new.column2

What is the alternative? This is a trigger code for domain index.

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center