I have the below code that calls an Oracle Package proc and fills an
ADO.Net Datatable with the values of the output refcursor parameter.
Everything works fine except one problem...it trims values and also
assigns nulls for empty strings. Example: "DDD " will be put into the
datatable as "DDD" and "" will be null. Anybody have this problem and if
so, is there a workaround? The client needs to be able to store spaces.
cmd.ExecuteNonQuery()
Dim DT as New DataTable
Dim refcur As Oracle.DataAccess.Types.OracleRefCursor
Dim DA As New Oracle.DataAccess.Client.OracleDataAdapter
refcur = CType(cmd.Parameters("Out").Value,
Oracle.DataAccess.Types.OracleRefCursor)
DA.Fill(DT, refcur)
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
