CREATE PROC PROC_Name ( @EMPID BIGINT, @EMPNAME VARCHAR(50) ) AS BEGIN INSERT INTO EMPLOYEE(EMPID,EMPNAME) VALUES (@EMPID,@EMPNAME) END

create or replace procedure projprssample (rs out sys_refcursor) is begin open rs for select * from users where rownu<=10; end;

create or replace procedure projprssample (rs out sys_refcursor) is begin open rs for select * from users where rownu<=10; end;

Create Procedure GetCustomerInfoById ( @CustomerId INT ) As BEGIN SELECT * FROM Customer where CustomerId=@CustomerId END