Oracle stored Procedure output parameter assignment exception: the type initializer for "Oracle.DataAccess.Types.OracleString" throws an exception.

Scene:

Wrote a stored procedure with a return parameter, which is normal on a different developer's machine. Other machines reported title errors. The depressing thing is that all callers are clients, there is no issue of version inconsistency that is said on the web.

Analysis:

Although the online post did not solve the problem at all, but still gave some Silk Road. Parameter value type problem. Also, I can also call the output parameter assignment statement (only if the result is not returned). I tried to oraclestring the type to Oracle, forcing a string to the CLR.

DICPARAOUT[KVP. Key] = (string) command. Parameters[0]. Value;

DICPARAOUT[KVP. Key] = (oraclestring) command.parameters[0]. Value;

Solve:

Take a try and try it. ToString (). It's done.

DICPARAOUT[KVP. Key] = command. Parameters[0]. Value.tostring ();

Reference Posts:

Http://www.cnblogs.com/keyrratuff/archive/2010/02/04/1663791.html

Oracle stored Procedure output parameter assignment exception: the type initializer for "Oracle.DataAccess.Types.OracleString" throws an exception.