Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Triggers and packages procedures
Check your access to the procedure
grant execute on <procedure> to <user schema where the trigger is defined>;
Eric Lepage <elepage_at_dynagram.com> wrote in article
<380F7787.841E229C_at_dynagram.com>...
> Hello,
>
> I have created a package which contains a procedure that I would like to
> call from a trigger. However, I can't compile the trigger because of the
> following error:
>
> PLS-00201: identifier 'PKG_MAKE.SETLASTMAKENO' must be declared
> PL/SQL: Statement ignored
>
> The trigger body is:
> BEGIN
> SELECT TO_CHAR(Make_Seq.NextVal, '0000') INTO :new.NoFab FROM DUAL;
> pkg_Make.SetLastMakeNo(:new.NoFab);
> END;
>
> pkg_Make is the package name where SetLastMakeNo is defined. I can call
> it from SQL*Plus but I don't know how to include this procedure call in
> a trigger.
>
> Thanks for any help,
> _______________________________
> Eric Lepage - Dynagram Software ( http://www.dynagram.com )
>
Received on Fri Oct 22 1999 - 04:42:50 CDT