Getting PLS-00905: object APPS.APPS is Invalid
Hello friends,
I have a sample test package with one proc as below.
Package Spec
--------------
CREATE OR REPLACE PACKAGE APPS.samir_test
IS
PROCEDURE samir_test_p (p_employee_number IN VARCHAR2);
END samir_test;
/
Package Body
--------------
CREATE OR REPLACE PACKAGE BODY APPS.samir_test
IS
PROCEDURE samir_test_p (p_employee_number IN VARCHAR2)
IS
x_emp_num NUMBER;
BEGIN
SELECT employee_number into x_emp_num FROM per_all_people_f WHERE employee_number = p_employee_number;
END samir_test_p;
END samir_test;
/
Now, I call the proc samir_test_p as below.
DECLARE
p_employee_number number := 2000121;
BEGIN
apps.samir_test.samir_test_p ( p_employee_number);
END;
I get following error.
ORA-06550: line 7, column 3:
PLS-00905: object APPS.APPS is invalid
ORA-06550: line 7, column 3:
PL/SQL: Statement ignored
But, if I remove apps. qualifier and call it using samir_test.samir_test_p ( p_employee_number);
it works.
I would like to know why it does not like the qualifier here. We have a need to use qualifier in our code.
Please help.
Thanks in Advance.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart