Database trigger and Procedures, with Oracle 7.3...

Hello all,

I have a Question.
Is it right, that Oracle can't match the types of ':new' and 'MyTable%type' in the trigger below ?

The following sample explain my problem. The trigger-compilation fails.

create table MyTable (MyRow number(5));
create or replace package mypackage is
procedure MyProc(TheNew MyTable%type);
end;
/

create or replace trigger MyTrick after insert on MyTable for each row begin
  mypackage.MyProc(:new);
end;
/

 Daniel Received on Wed Sep 10 1997 - 00:00:00 CDT