* HELP * - Using :NEW in a trigger

I have a trigger that I would like to call a stored procedure from and pass the :NEW record variable to, however I don't seem to be able to do this. The code is as follows :-

CREATE OR REPLACE
  PROCEDURE SDG_INSERT_TRIGGER_PROC (temp SDG%rowtype) AS   id VARCHAR2(20);
  BEGIN

• This is a test id := temp.IDENTITY; END;
  /
  

CREATE OR REPLACE TRIGGER SDG_INSERT_TRIGGER   BEFORE INSERT
    ON SDG
    FOR EACH ROW
DECLARE
BEGIN

• Try to call the procedure sdg_insert_trigger_proc (:NEW); END;
  /
  

I have tried :NEW, NEW and NEW%ROWTYPE and :NEW%ROWTYPE but all to no avail. Is what I want to do even possible?. Please email at the above address or post something here. Thanks in advance... Received on Tue Feb 21 1995 - 18:17:46 CET