This discussion is archived
1 Reply Latest reply: Apr 18, 2013 2:49 PM by DmitryTolpeko(SQLines) RSS

How to Write Procedure with Same no. of parameter in Oracle & SQl Server?

879152 Newbie
Currently Being Moderated
Sql Server Procedure:

CREATE PROC proc1
AS
SELECT ename FROM employee


Oracle Server Procedure:

CREATE OR REPLACE PROCEDURE proc1
(
cv_1 IN OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN cv_1 FOR
SELECT ename
FROM employee ;
END;



Is it possible to write this procedure in both Oracle & Sql Server
with Same number of parameter with same supported data type?
If possible how?
Please help me.

Thanks
Solaiman

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points