PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared

[Richard Anderson]

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:
PL/SQL: Statement ignored

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

[sybrandb]

"Richard Anderson" <ra*******@viops.com> wrote in message news:<4h******************@twister.austin.rr.com>. ..

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:
PL/SQL: Statement ignored

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

The syntax to call a procedure in a package is
<package name>.<procedure name>

Please verify this in your manual.

Sybrand Bakker
Senior Oracle DBA