Term: OUT

Definition:
In Oracle PL/SQL, the term OUT refers to one of the parameter passing modes. Unlike the IN parameter mode, it must be specified in the parameter declaration. An OUT parameter is a 'pass by value' method. The parameter must be assigned with a value within the subprogram body. This value is then passed to the host environment, from where the subprogram has been called.

Notes

1. A default value cannot be assigned to the OUT parameter.
   
2. The NOCOPY hint can be used in the parameter declaration to convert the parameter calling method from 'Call by Value' method to the 'Call by reference' method.

PARAMETER [IN | OUT | IN OUT] [DATA TYPE] [DEFAULT],

CREATE OR REPLACE PROCEDURE P_GET_SAL (P_EMPID NUMBER, P_SAL OUT NUMBER)

IS

BEGIN

SELECT SALARY

INTO P_SAL

FROM EMPLOYEE

WHERE EMPLOYEE_ID=P_EMPID;

END;

SQL> VAR G_SAL NUMBER;

SQL> EXEC P_GET_SAL(100,:G_SAL);



PL/SQL procedure successfully completed.



SQL> PRINT G_SAL;



 G_SAL

----------

      2300

• AnyData Data Type: Example using OUT
• Oracle Procedures: Examples using OUT
• Exception Handling: Notes on OUT
• PL/SQL Warnings: Examples & Notes on OUT

• Spell out numbers to words - This handy little script will spell out numbers to words. For example...
• ANSI Joins: OUTER JOIN - Example of an ANSI-style OUTER JOIN
• FUNCTIONS: without parameters - Not all functions take parameters; some produce output without eva...
• FUNCTIONS: with output parameters - This is a sample of a function that outputs a parameter.
• FUNCTIONS: IN OUT parameter - When you create a procedure or function, you may define parameters. ...