PLS-00302: Component Must Be Declared — Causes and Fixes

The function is in the code, yet every call fails with PLS-00302. Oracle doesn't see the code you see: it sees the package specification, under the name and schema it resolves.

How Oracle Resolves the Name

Oracle resolves a.b left to right: it finds a (a schema, package or variable in scope), then looks for b inside it. PLS-00302 means b wasn't found inside the a it chose.

BEGIN
  v := agr_pkg.nbr_cgms_agrmnt(101);
END;

Cause 1: Not in the Spec

Only items declared in the package specification are visible outside the package.

CREATE OR REPLACE PACKAGE agr_pkg AS
  FUNCTION nbr_cgms_agrmnt(p_id NUMBER) RETURN NUMBER;
END agr_pkg;
/

Cause 2: Name Mismatch

A typo, or an identifier created in double quotes, which makes it case-sensitive and must then always be quoted.

SELECT object_name, procedure_name
FROM all_procedures
WHERE object_name = 'AGR_PKG';

Cause 3: Name Collision

If a schema or local object has the same name as the package, Oracle may resolve to it and then fail to find the component. Qualify with the owner.

v := fin_owner.agr_pkg.nbr_cgms_agrmnt(101);