User was getting SQL0551N "JenB" does not have the privilege to perform operation "EXECUTE" on object "EMPLOY.P10020". SQLSTATE=42501

I tried the following:
Grant execute on package EMPLOY.P10020 to user JenB;

But got this:
SQL0204N "EMPLOY.P10020" is an undefined name.

I saw the exact package (P10020) with the right schema (EMPLOY) under syscat.packages in the database using

"select pkgschema, pkgname from syscat.packages where pkgname = 'P10020' "

Why am I still getting SQL0204N "EMPLOY.P10020" is an undefined name ?

Please advise. Thanks in advance!

Is EMPLOY.P10020 a procedure? If so you must grant execute on the procedure, not on the package (although in version 7 you would have granted execute on the package). Check out the GRANT statement in the SQL Reference Vol 2 for more info.

Object is listed under syscat.packages so it should be a package, right?
The same name cannot be found under syscat.procedure.

Any other suggestions?

Thanks.

Procedures also have packages, but you must grant execute to the procedure. Is this a program with embedded SQL (C++, etc), a function, procedure, etc? Need more info about what EMPLOY.P10020 is. Also include full info about OS, DB2 version, etc.

Database is DB2 v9.1 on AIX 5.3

After we did a bind on all stored procedures and application, the problem is resolved.

Thank you very much for your help!