Check error for procedure : Compile Error « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Compile Error

Check error for procedure

    
SQL>
SQL>
SQL>
SQL> create or replace procedure A(p number) is
  2    begin
  3        B(p+1);
  4    end;
  5   /

Warning: Procedure created with compilation errors.

SQL>
SQL> show errors
Errors for PROCEDURE A:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/7      PL/SQL: Statement ignored
3/7      PLS-00905: object JAVA2S.B is invalid
SQL>
SQL> create or replace procedure B(p number) is
  2    begin
  3        A(p+1);
  4    end;
  5   /

Warning: Procedure created with compilation errors.

SQL>
SQL>
SQL> show errors
Errors for PROCEDURE B:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/7      PL/SQL: Statement ignored
3/7      PLS-00905: object JAVA2S.A is invalid
SQL>

   
    
    
    
  

Related examples in the same category