C# with plsql in Visual Studio 2010

Question

How to write the crud application with plsql package?

Logic should be implemented using plsql function and procedures and bundled as Oracle package.

Answer 1

create or replace package body details_pkg is


     PROCEDURE details(
                 emp_details OUT T_CURSOR_SELECT
     )

     IS CURSORREF T_CURSOR_SELECT;
     BEGIN

        OPEN CURSORREF FOR SELECT * FROM Employees;
        emp_details:= CURSORREF;

     END details;
end details_pkg;