Enterprise Library and Oracle Ref Cursors

Thankfully I found someone's comment on the EntLib forum about the fact that the Data Access block adds a ref cursor automatically and that even more importantly, the cursor has to be name "cur_OUT" in the Oracle stored procedure

So e.g.

46 Public Sub FillBySearchId(ByVal searchId As Integer, ByVal dsSearch As CAPS.TLC.Data.SearchDataSet)

47 Dim cmd As DbCommand = m_DB.GetStoredProcCommand("ADDQUESTIONPKG.GetADDQUESTIONByID")

48

49 dsSearch.LE_ADD_QUESTION.Clear()

50

51 m_DB.AddInParameter(cmd, "p_SEARCH_ID", DbType.Decimal, searchId)

52 m_DB.LoadDataSet(cmd, dsSearch, Me.OnGetTableName())

53

54 dsSearch.LE_ADD_QUESTION.AcceptChanges()

55 End Sub