illegal procedure call : Call « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Call

illegal procedure call

  
SQL>
SQL> set serveroutput on
SQL>
SQL> CREATE OR REPLACE PROCEDURE CallProc1(p1 IN VARCHAR2 := NULL) AS
  2  BEGIN
  3    DBMS_OUTPUT.PUT_LINE('CallProc1 called with ' || p1);
  4  END CallProc1;
  5  /

Procedure created.

SQL> BEGIN
  2    CALL CallProc1();
  3  END;
  4  /
  CALL CallProc1();
       *
ERROR at line 2:
ORA-06550: line 2, column 8:
PLS-00103: Encountered the symbol "CALLPROC1" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "CALLPROC1" to continue.

   
  

Related examples in the same category