Oracle and call stored procedure problems connecting the English character set

A problem with an Oracle database that is deployed on IIS that WebService connect the English character set is "not registered on the local computer" msdaora.1 "provider" with the following solution:

Cause: such as an error, the 64-bit system is not registered with the "msdaora.1" provider

Workaround: Locate your Web site in the IIS application pool, open the advanced settings, and set "enable 32-bit application" to "True".

There are other solutions, such as setting the project target platform to x86, using other connection strings, and so on. Changing the application pool is the simplest and easiest, and does not change the project and code.

Methods for calling stored procedures:

Call Pro_name (parameter 1, parameter 2, Parameter 3 ...) (Note: If it is a string type of add ', if it is number does not add single quotation marks, if the date is to be formatted according to the date (To_date (",") in Oracle))

Oracle and call stored procedure problems connecting the English character set