Out parameter is assignable : Parameter OUT « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Parameter OUT

Out parameter is assignable

    
SQL>
SQL>
SQL> CREATE TABLE myTable3 (
  2      a INTEGER,
  3      b INTEGER
  4  );

Table created.

SQL>
SQL> CREATE or replace PROCEDURE addtuple3(a NUMBER, b OUT NUMBER)
  2  AS
  3  BEGIN
  4      b := 4;
  5      INSERT INTO myTable3 VALUES(a, b);
  6  END;
  7  /

Procedure created.

SQL>
SQL> DECLARE
  2      v NUMBER;
  3  BEGIN
  4      addtuple3(10, v);
  5  END;
  6  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table myTable3;

Table dropped.

   
    
    
    
  

Related examples in the same category