Can a Trigger call StoredProc(:new) ( Ora 7.3 )

From: <Torsten.Reichert_at_gmx.net>
Date: Tue, 02 Nov 1999 19:41:34 +0100
Message-ID: <381F305E.D10EC83B@gmx.net>

Hi,

What is the type of :new and :old records of a trigger ? Is there any possibility

• to pass assign the :new variable in a trigger to procedures
• or assign its value to another variable ?

I want to do something like that:
PROCEDURE StoredProc ( alt IN OUT test_c%ROWTYPE, neu IN OUT test_c%ROWTYPE ) IS
BEGIN
  NULL;
END StoredProc;

CREATE OR REPLACE TRIGGER boss
  AFTER INSERT OR UPDATE OR DELETE ON test_c   FOR EACH ROW

• REFERENCING old as old_rec BEGIN StoredProc ( :old, :new ); END;

Thank you very much

Received on Tue Nov 02 1999 - 12:41:34 CST