pls-00905 Input parameter type definition can not use the schema when create a procedure
I want to create a test procedure in the test database, then bring the error message
"pls-00905: object PESD.PESD is invalid
pl/sql: Compilation unit analysis terminated "
The procedure is very simple, all the content is:
CREATE OR REPLACE procedure PESD.TEST(V_KIND_NO IN pesd.drp001t0.kind_no%type,
V_KIND_NAME IN pesd.drp001t0.kind_name%type)
IS
BEGIN
NULL;
END;
/
sql>desc pesd.drp001t0
Name Type Nullable Default Comments
----------- ------------- -------- ------- --------
KIND_ID VARCHAR2(4)
KIND_NAME VARCHAR2(30)
If remove the schema of the input parameter's definition, then no errors.
pl/sql: Compilation unit analysis terminated "
The procedure is very simple, all the content is:
CREATE OR REPLACE procedure PESD.TEST(V_KIND_NO IN pesd.drp001t0.kind_no%type,
V_KIND_NAME IN pesd.drp001t0.kind_name%type)
IS
BEGIN
NULL;
END;
/
sql>desc pesd.drp001t0
Name Type Nullable Default Comments
----------- ------------- -------- ------- --------
KIND_ID VARCHAR2(4)
KIND_NAME VARCHAR2(30)
If remove the schema of the input parameter's definition, then no errors.
0