1 Reply Latest reply: Apr 18, 2013 4:49 PM by DmitryTolpeko(SQLines) RSS

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

    879152
      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