CALL statement. : Call « Stored Procedure Function « Oracle PL / SQL

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

CALL statement.

  
SQL>
SQL> CREATE OR REPLACE PROCEDURE CallProc2(p1 IN OUT VARCHAR2) AS
  2  BEGIN
  3    DBMS_OUTPUT.PUT_LINE('CallProc2 called with ' || p1);
  4    p1 := p1 || ' returned!';
  5  END CallProc2;
  6  /

Procedure created.

SQL>
SQL> set serveroutput on
SQL>
SQL> CALL CallProc2(:v_Output);
CallProc2 called with Hello!

Call completed.

SQL> PRINT v_Output

V_OUTPUT
--------------------------------------------------------------------------------
Hello! returned!

SQL>
SQL>
SQL>

   
  

Related examples in the same category