[bug_report] Creating triggers using Oracle fails.

[mdaems]

Hi All,

i have trigger:

Code: Select all

CREATE TRIGGER TRIPORTOK_INSERT_AZON BEFORE
INSERT ON TRIPORTOK FOR EACH ROW DECLARE
BEGIN
  EXECUTE IMMEDIATE 'SELECT TRIPORTOK_FAZONOSITO_SEQ.NEXTVAL FROM DUAL' INTO :NEW.FAZONOSITO;
END;

If I run this SQL command in "Oracle 9i SQL Plus" it works OK. If I call this command in my code with a TZSQLProcessor it is not working. The trigger will be available, but it is invalid...????

Can anybody help me? How can I create it to make it work?
Attila

ps: The sequenser is exist: TRIPORTOK_FAZONOSITO_SEQ.