Nope....for the archives....9.2.0.7.0 didn't solve the problem. I can
write a value with spaces but when I try to read it into a dataset, it
trims the value and then the primary key fails. I really do hate oracle.
Message from Franklin W Gray/USABB/NONABB received on 10/11/2005 05:09 PM
10/11/2005 05:09 PM
Internal
Franklin W Gray/USABB/NONABB
.
To: "Unmoderated discussion of advanced .NET topics."
<[email protected]>
cc:
Subject: Re: [ADVANCED-DOTNET] Oracle provider trimming values
Thanks Frans. I'm glad I'm pulling my hair out because of somebody else's
code and not mine :)
Message from Frans Bouma <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM received
on 10/11/2005 04:56 PM
10/11/2005 04:56 PM
Frans Bouma <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM
Please respond to "Unmoderated discussion of advanced .NET topics."
<[email protected]>
Sent by "Unmoderated discussion of advanced .NET topics."
<[email protected]>
To: [email protected]
cc:
Subject: Re: [ADVANCED-DOTNET] Oracle provider trimming values
> 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)
If you're using ODP.NET 9.2.0.401, it's a bug in that version, you
should upgrade to their latest version 9.2.0.7.0.
Frans
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
