How to write stored procedure in Oracle for .Net ?
I struggled a lot to get the proper stored procedure in oracle for .Net ,
but finally tried this approach and it worked.

For Adding

CREATE OR REPLACE PACKAGE "PackInsurance" AS
-- FUNCTION MyFunction(Param1 IN NUMBER) RETURN NUMBER;

PROCEDURE AddNewInsurerCode(insurerCode IN VARCHAR2);
END "PackInsurance";
/

CREATE OR REPLACE PACKAGE BODY "PackInsurance" AS
PROCEDURE AddNewInsurerCode ( insurerCode IN VARCHAR2)
IS BEGIN
INSERT INTO tblINSURER (PROD_GRP_ID, INSURER_CD) VALUES (2 , insurerCode);
END AddNewInsurerCode;

END "PackInsurance";
/

Very soon I will update on the selection of data in Ref Cursor :
For Selecting data