Re: calling a procedure from a trigger in oracle 7.3

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 18 Apr 1998 02:51:01 GMT
Message-ID: <6h94et$ehm@bgtnsc03.worldnet.att.net>

On Thu, 16 Apr 1998 14:40:10 -0500, John Franklyn <john.franklyn_at_workplacesystems.com> wrote:

>Does anyone have an example of how to call a procedure from within a
>trigger in Oracle 7.3? I have a trigger the calculates area totals. I
>would like to pass the area total to a procedure, for update of another
>table. Any input would be greatly appreciated. Thanks.

Calling a procedure from a trigger is very simple. See the following example:

create trigger trig_name

	after insert on table_name
	for each row
begin
	your_procedure_name (XXX,YYY);

end;
/

Is this what you are after? Received on Fri Apr 17 1998 - 21:51:01 CDT