Re: Trigger row as parameter for procedure call?

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.

See the referencing clause in the SQL Manual. You can reference the table row columns using :NEW (insert,update) and :OLD (update, delete) by default.

HTH
-- Mark D Powell -- Received on Mon Feb 18 2002 - 09:31:41 CST