Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Triggers and packages procedures
You can try this way:
create public synonym PKG_MAKE for PKG_MAKE
I hope this resolve your problem.
Bye
Eric Lepage ha scritto nel messaggio <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 - 03:14:05 CDT