Re: Database trigger and Procedures, with Oracle 7.3...

When I changed

     procedure MyProc(TheNew MyTable%type);

to

     procedure MyProc(TheNew MyTable.MyRow%type);

and

     mypackage.MyProc(:new);

to

     mypackage.MyProc(:new.MyRow);

I was able to get the code to compile.

flux wrote:
>
> 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
 

-- 
Frank Hubeny            
fhubeny_at_ntsource.com            
Wheaton, IL 60187