Use named notation : Procedure Call « Stored Procedure Function « Oracle PL / SQL






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

Use named notation

   

SQL> CREATE OR REPLACE PROCEDURE CallMe(pA VARCHAR2,pB NUMBER,pC BOOLEAN,pD DATE) AS
  2  BEGIN
  3    NULL;
  4  END CallMe;
  5  /

SP2-0804: Procedure created with compilation warnings

SQL>
SQL> DECLARE
  2    v1 VARCHAR2(10);
  3    v2 NUMBER(7,6);
  4    v3 BOOLEAN;
  5    v4 DATE;
  6  BEGIN
  7    CallMe(pA => v1, pB => v2,pC => v3,pD => v4);
  8  END;
  9  /

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.Call a stored procedure in a PL/SQL block
2.Call a stored procedure then other statements
3.Dependency Example
4.Forward Declarations
5.Exceptions in Subprograms
6.A PL/SQL procedure with no parameter
7.Exception throwed out of procedure call
8.Default parameter value
9.Pass parameter by data type
10.Calling ParameterLength illegally (ORA-6502)...
11.Use named notation, but with a different order of the formal parameters
12.This script demonstrates how to create and call a simple procedure.