RDBMS PLSQL Program 26 Procedure with in and out parameters and program to call it

Procedure

======================================================= 

CREATE or REPLACE PROCEDURE pro1(veno in char,temp out emp%rowtype)

IS

BEGIN

    SELECT * INTO temp FROM emp WHERE Eno = veno;

END;

/

Program to call above procedure

=======================================================

set serveroutput on

DECLARE

    temp emp%rowtype;

    veno emp.eno%type;

BEGIN

    veno :='&veno';

pro1(veno,temp);

    dbms_output.put_line(temp.eno||' -> '||temp.ename||' -> '||temp.edno||' -> '||temp.esalary);

END;

/