Re: Trigger row as parameter for procedure call?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 18 Feb 2002 05:43:49 -0800
Message-ID: <a20d28ee.0202180543.7f0e9ea6@posting.google.com>

marknyhan_at_hotmail.com (Mark Nyhan) wrote in message news:<3d327694.0202180306.6c5b1744_at_posting.google.com>...
> Hi,
>
> I am trying to create a trigger on a Test table that when it is
> updated or inserted into that that row will pass its TestId as a
> parameter to another procedure that generates XML for the test.
>
> CREATE OR REPLACE TRIGGER assessment_trigger
> AFTER INSERT OR UPDATE ON tests
> FOR EACH ROW
> BEGIN
>
> export.assessment('143');
> -- This procedure creates an XML file on the server
>
> END assessment_trigger;
> /
>
> I want to pass the TestId of the updated row as the value of the
> parameter that is called by the trigger, is this possible. Any help
> would be great.
>
> Thanks Mark.

All variables are available using the :new.<columnname> syntax for the current value and the :old.<columnname> syntax for the previous value. Please try to the read the Oracle Application Developers guide or just search on trigger on http://tahiti.oracle.com *before* posting.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Feb 18 2002 - 07:43:49 CST