Have you tried the 10.1.0.3.01 provider from Oracle, I tried microsofts provider, and the 9x ODP and even trying Odbc wrappers till I decided to try the 10g provider. I've not had any problems with it , yet, and I run queries against 8 and 9i databases.
Dave On 12/10/05, Franklin Gray <[EMAIL PROTECTED]> wrote: > > 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<http://DISCUSS.DEVELOP.COM>received > on 10/11/2005 04:56 PM > > 10/11/2005 04:56 PM > > > > Frans Bouma <[EMAIL > PROTECTED]>@DISCUSS.DEVELOP.COM<http://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 <http://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(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > > > > > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > -- Dave Jones [EMAIL PROTECTED] [EMAIL PROTECTED] =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
