Re: PL/SQL Stored Procedure Question

> The following create procedure is not working.
>
> SQL> create procedure shwemp (emp_id number) is
> 2 begin
> 3 select empno, ename from emp where empno = emp_id;
> 4 end;
> 5 /
>
> Warning: Procedure created with compilation errors.
>

The procedure needs a way to return the values fetched in the select statment. It would look something like this:

   create procedure shwemp (emp_id number,

                            p_empno out number,
                            p_ename out varchar2) is
   begin
     select empno, ename
       into p_empno, p_ename
       from emp 
      where empno = emp_id;

  /JanH Received on Fri Jan 19 1996 - 00:00:00 CET