Oracle.DataAccess.Client and SqlDataSource in ASP.NET
624437Feb 21 2008 — edited Jun 1 2009Hello.
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.