I thought I submitted this answer but I don't have it in my email. Turned out that the data was being retrieved right and saved right once I set the size property. Seems the real problem is that when I go to apply a primary key on the column, that's when the trimming takes place (must be trimming because it fails the unique test but it is unique).
I've gotten permission to require the users to put something instead of spaces at the end of a column value to make it unique Thanks for you help though. Message from Frans Bouma <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM received on 10/12/2005 04:12 PM 10/12/2005 04:12 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 > 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 =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
