Re: PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared

From: <sybrandb_at_yahoo.com>
Date: 18 Nov 2003 00:37:29 -0800
Message-ID: <a1d154f4.0311180037.1b7fa1f6_at_posting.google.com>


"Richard Anderson" <randerson_at_viops.com> wrote in message news:<4hdub.63788$PH6.2146_at_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 Received on Tue Nov 18 2003 - 09:37:29 CET

Original text of this message