XSD data set with Oracle database

Question

Hi folks,

I'm having a major issue with an XSD dataset mapping thingy that I'm using within my current project. We are using XSDs for some data abstraction (it's quicker and debatably more maintainable that using Parameterised SQL or a StoredProc), and on my machine (running in the VS development environment) thy're working fine.

However, on the Pre-production server we use for our testing, the XSDs are not working correctly: some method calls will fail 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 issue before? The methods being called are simple select statements using 1-3 parameters, and as I said before they work fine on my machine.

Answer 1

Is the Pre-Production server using the same exact Oracle client as your development machine? Could there be characterset differences between what you are doing on your Dev machine vs. the pre-production machine?

Which XSD mapping tool are you using (or is it homegrown)?