XSD Dataset with Oracle Database

I am having a serious problem displaying the XSD dataset that I am using in my current project. We use XSD for some data abstraction (it is faster and more debatable to maintain using parameterized SQL or StoredProc), and on my machine (working in the VS development environment) your work works fine.

However, on the Pre-production server, which we use for our testing, XSDs do not work correctly: some method calls will not be executed with the following error:

System.ArgumentException: Value does not fall within the expected range.
at Oracle.DataAccess.Client.OracleParameter.set_DbType(DbType value)

Has anyone ever encountered this problem before? The called methods are simple select statements using 1-3 parameters, and, as I said, they work fine on my machine.

+3
source share
1 answer

We also encountered this problem after converting our data sets (XSD) using System.Data.OracleClient to Oracle.DataAccess.Client .

, " Number" ProviderType. Oracle . ProviderType . " Decimal" ProviderType, , , . "", "" "".

, -.

+1

Source: https://habr.com/ru/post/1740290/


All Articles