Stored Procedure example

Hi,
I was wondering if someone has a simple sample stored procedure which does a SELECT.

Something like:

create procedure sp_select_emp(@empid int) as
select * from emp where emp_no = @emp_id; end;

This format works for Sybase. How do I convert it to Oracle format?

Thanks,
Arun.

Received on Mon Oct 05 1998 - 13:53:28 CDT