Example of In Out Parameter

Example of  IN OUT  Parameter

-- Created on 8/7/2012 by TAHIR

declare

  -- Local variables here

  a number :=101;

  b varchar2(50);

  c number;

begin

  -- Test statements here

  printempinfo(a,b,c);

  dbms_output.put_line(a||b||c);

end;

create or replace procedure PrintEmpInfo(empno in out employeeTest.eno%type, v_name out employeeTest.ename%type, v_salary  out employeeTest.esalary%type)

is

begin

Select  eno,ename,esalary  into empno, v_name, v_salary

from employeetest

where eno= empno;

end printEmpInfo;