<oracle.dataaccess.client>
  <settings>
    <add name="&quot;HMS&quot;.&quot;PROJECT_INSERT&quot;.RefCursor.OUTPARAM" value="implicitRefCursor bindinfo='mode=Output'" />
    <add name="&quot;HMS&quot;.&quot;PROTOCOL_INSERT&quot;.RefCursor.OUTPARAM" value="implicitRefCursor bindinfo='mode=Output'" />
    <add name="&quot;HMS&quot;.&quot;CONTAINER_INSERT&quot;.RefCursor.OUTPARAM" value="implicitRefCursor bindinfo='mode=Output'" />
    <add name="&quot;HMS&quot;.&quot;CONTONST_INSERT&quot;.RefCursor.OUTPARAM" value="implicitRefCursor bindinfo='mode=Output'" />
    <add name="&quot;HMS&quot;.&quot;TYPE_INSERT&quot;.RefCursor.OUTPARAM" value="implicitRefCursor bindinfo='mode=Output'" />
    <add name="&quot;HMS&quot;.&quot;PROPERTY_INSERT&quot;.RefCursor.OUTPARAM" value="implicitRefCursor bindinfo='mode=Output'" />
  </settings>
  </oracle.dataaccess.client>

===================

create or replace
PROCEDURE CONTAINER_INSERT
  (
    ProtocolID_IN IN number,
    ParentcontainerID_IN IN number,
    TypeID_IN IN number,
    ContainerDesc_IN IN varchar2,
    outParam OUT SYS_REFCURSOR
  )
IS
ContainerID_OUT NUMBER;
BEGIN
  INSERT into container (protocolid,parentcontainerid,typeid,descr)
  values (ProtocolID_IN,ParentcontainerID_IN, TypeID_IN, ContainerDesc_IN) returning containerid into ContainerID_OUT;

  OPEN outParam FOR SELECT ContainerID_OUT as "ContainerID_OUT" FROM DUAL;
END;

==================