Home » RDBMS Server » Server Administration » Trigger-Help
Trigger-Help [message #369863] Fri, 27 October 2000 17:47 Go to next message
Ana
Messages: 23
Registered: October 2000
Junior Member
Need help.
I want to call a stored procedure in trigger after update.
Stored procedure is working which require 4 IN parameters.

How to pass these parameters within trigger. these 4 values are available in table.

Ana

Report message to a moderator

Re: Trigger-Help [message #369865 is a reply to message #369863] Mon, 30 October 2000 01:01 Go to previous message
AndreaB
Messages: 5
Registered: October 2000
Junior Member
you can use the sintax :new.column_name (the value after the update operation) or :old.column_name (the value before the update operation)

Report message to a moderator

Previous Topic: UTL_FILE file permission prob.
Next Topic: Management Server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 04:01:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.