> 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.
Before you go off hammering Larry on the head with a large pile of
SqlServer books, could it be that the dataset trims the
value? If you use a datareader and check the value, is it trimmed then?
FB, who not really hates oracle, just the guys who write teh
installers at 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 DevelopMentorR http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>
>
>
>
>
> ===================================
> This list is hosted by DevelopMentorR 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
