> Thanks Frans. I'm glad I'm pulling my hair out because of
> somebody else's code and not mine :)
It still could be I misinterpreted your code, but it looks like
something I ran into some time ago with 9.2.0.401 about
patterns for a LIKE Statement with spaces which were stripped off, exactly like
you experience.
FB
>
>
>
>
> 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
