PL/SQL (MOSC)

MOSC Banner

pls-00905 Input parameter type definition can not use the schema when create a procedure

edited May 18, 2010 3:04PM in PL/SQL (MOSC) 8 commentsAnswered
  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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center