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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Aug 23 03:18:43 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.