'Возвращает NSNID и строку
    Public Shared Function GET_NSN_NSJ_ID_CURSOR_TMP(ByVal pNSN_NSJ_SGID As Long, _
                                                     ByRef strresult As String, _
                                                     ByVal pOracon As OracleConnection) As Long
        Dim res As Long = 1
        strresult = ""
        Dim cmd As OracleCommand = New OracleCommand("PKG_NSNNSJDIC_DMSERVICE.GET_NSN_NSJ_ID_CURSOR_TMP", _
                                                     pOracon)
        cmd.CommandType = Data.CommandType.StoredProcedure
        cmd.Parameters.Add("P_SGRPID", OracleType.Number).Direction = ParameterDirection.Input
        cmd.Parameters("P_SGRPID").Value = pNSN_NSJ_SGID
        cmd.Parameters.Add("RESULT", OracleType.Cursor).Direction = ParameterDirection.ReturnValue
        Try
            'выполняем команду
            Dim rdr As OracleDataReader = cmd.ExecuteReader
            If rdr.Read() Then
                res = CLng(rdr.Item("PK"))
                strresult = rdr.Item("NSN_NSJ").ToString()
            End If

            rdr.Close()
            'закрываем соединение

        Catch ex As Exception
            'если соединение открыто, то закрыть
            MsgBox(ex.Message.ToString)
            res = 1
            strresult = ""
        End Try
        Return res
    End Function

пакет 

   TYPE U_CURSOR IS REF CURSOR;
....
   FUNCTION GET_NSN_NSJ_ID_CURSOR_TMP (P_SGRPID NUMBER)
      RETURN U_CURSOR
   IS
      P_CURSOR    U_CURSOR;


....
     OPEN P_CURSOR FOR
         SELECT ID PK, V_NSN_NSJ NSN_NSJ
           FROM DUAL;
      RETURN P_CURSOR;
...