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_erro rs 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_applicati on_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:
SQLexecute 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
(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_erro rs 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_applicati on_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:
SQLexecute 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
Comment