Home » Server Options » Text & interMedia » OLD AND NEW In INSERT TRIGGER
OLD AND NEW In INSERT TRIGGER [message #76029] Thu, 13 March 2003 11:18 Go to next message
SS
Messages: 46
Registered: November 2001
Member
Hello,

I am trying to invoke a stored procedure from a BEFORE-INSERT TRIGGER.
I'd like to invoke it with :new values in its arguments.
However I get a message saying :OLD and :NEW cannot be used in table level triggers.
How can I resolve this?

Thanks.
Re: OLD AND NEW In INSERT TRIGGER [message #76030 is a reply to message #76029] Fri, 14 March 2003 02:50 Go to previous message
Mooders
Messages: 2
Registered: March 2003
Junior Member
SS

:old and :new values cans only be used in row level triggers, try inserting the FOR EACH ROW syntax.

Jon
Previous Topic: ORACLE INTERMEDIA TEXT
Next Topic: Intermedia seach using multi-language data in 1 column
Goto Forum:
  


Current Time: Thu Mar 28 08:55:29 CDT 2024