Triggers and packages procedures

From: Eric Lepage <elepage_at_dynagram.com>
Date: Thu, 21 Oct 1999 16:28:55 -0400
Message-ID: <380F7787.841E229C@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 Thu Oct 21 1999 - 15:28:55 CDT