SELECT-Statement in Trigger in IF
Posted by:
Charlie
Date: October 29, 2005 05:14AM
Hi,
This code generates an error:
IF NEW_VALUE = '' THEN
SELECT column1 INTO NEW_VALUE FROM lkp_table where left(plz,4) = left(NEW.plz,4)) LIMIT 1;
END IF;
Isn't it allowed to use a select-statement in a trigger in a IF-Statement?
br
Charlie
Subject
Views
Written By
Posted
SELECT-Statement in Trigger in IF
16329
October 29, 2005 05:14AM
7045
October 31, 2005 03:39PM
6148
July 04, 2007 12:46AM
5687
July 04, 2007 12:46AM
5052
July 05, 2007 12:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.