PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared

I am having problems getting procedure to execute that is part of a package (actually any of the procedures/functions that are part of this package). I've extracted out one of the procedures and created a new package just to verify the error. The package header and body are below DROP PUBLIC SYNONYM TestPackage;
CREATE OR REPLACE PACKAGE TestPackage AS
-- This procedure deletes all the errors for the currently logged in user
PROCEDURE p_test_del_val_err;

END TestPackage;
/
Show errors

CREATE OR REPLACE PACKAGE BODY TestPackage AS
-- ************************************************************************

• Description: This procedure deletes the validation_errors table for the current user;
• Parameters: None PROCEDURE p_test_del_val_err IS BEGIN DELETE FROM dfars_err; COMMIT; EXCEPTION WHEN OTHERS THEN Raise_application_error(-20992, 'General Error in Delete Validation Errors',TRUE); END p_test_del_val_err; END TestPackage; / CREATE PUBLIC SYNONYM TestPackage for TestPackage; GRANT EXECUTE ON TestPackage TO PUBLIC; Show errors

When I compile it I get no errors but when I run the command "execute p_test_del_val_err" I get the followin errors: SQL> execute p_test_del_val_err
BEGIN p_test_del_val_err; END;

      *
ERROR at line 1:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared
ORA-06550: line 1, column 7:

It is probably a really simple problem but I just cannot see it. If anyone can point me in the right direction I would truly appreciate it.

Thanks
Rick Anderson Received on Tue Nov 18 2003 - 00:58:56 CET