IN Mode:

IN mode is used to read values from the subprogram. In Mode is a read-only variable where reading alone is done and no assignment is performed. Let consider the following example which describes the usage of the IN mode.

Example

CREATE OR REPLACE PROCEDURE DISP_ENAME(ENO IN NUMBER) IS #to create or replace a procedure #

MNAME VARCHAR2(20); # declaration of variable #

BEGIN

SELECT ENAME INTO MNAME FROM EMP WHERE EMPNO=ENO;

DBMS_OUTPUT.PUT_LINE('THE NAME IS '||MNAME);

END;

The procedure gets created. In sequence to execute the procedure, the statement EXEC is used as display below:

EXEC disp_ename(7902);

Displays,

EXEC DISP_ENAME(7902);

the name is FORD

PL/SQL procedure successfully finished.

This procedure uses the IN mode and shows the name of the employee.