Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle.DataAccess.Client and SqlDataSource in ASP.NET

624437Feb 21 2008 — edited Jun 1 2009
Hello.
I just wanted to confirm whether Oracle.DataAccess.Client (ODP.NET provider) is still incompatible with SqlDataSource when the query has got parameters.

For example, this query in SqlDataSource tag:

UpdateCommand=UPDATE ATLSM_OWNER."ATLSM_SITE" SET "SITE_DSCR" = :SITE_DSCR WHERE "SITE_ID" = :SITE_ID'

with:

<UpdateParameters>
<asp:Parameter Name="SITE_DSCR" Type="String" />
<asp:Parameter Name="SITE_ID" Type="Decimal" />
</UpdateParameters>

Works fine with: System.Data.OracleClient but it doesn't with: Oracle.DataAccess.Client

Many thanks.
Best Regards,
Eduardo.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2009
Added on Feb 21 2008
10 comments
11,895 views