Re: Trigger row as parameter for procedure call?

Apologies for still not figuring this out, I have been reading the manuals on the ":new.<columnname> syntax". I can reference the columns in this way and I know it passes the parameter to the procedure as it creates an XML file with the TestID as the name but for some reason it breaks down on the first cursor of the procedure it is calling.

CREATE OR REPLACE TRIGGER assessment_trigger AFTER INSERT OR UPDATE ON tests
FOR EACH ROW
BEGIN
export.assessment(:new.testid); -- Testid is a VARCHAR2 END assessment_trigger;
/

I can use the :old and :new to insert into other tables but not This procedure takes in the testid parameter and creates an XML file with that name so I know it is being passed. If I take the FOR EACH ROW out and hard code in a testid such as export.assessment('ID2354'); then it works fine, am I missing something obvious?

Thanks again,
Mark

Mark. Received on Mon Feb 18 2002 - 10:25:37 CST