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

Frank Hubeny wrote:

> 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

  Thats true, but i want to have the whole row, not only one column.

  Daniel Received on Thu Sep 11 1997 - 00:00:00 CDT