Trigger row as parameter for procedure call?

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. Received on Mon Feb 18 2002 - 05:06:11 CST