C#

<br />
CREATE OR REPLACE PROCEDURE spXXXXX (<br />
TestId varchar2,<br />
bAllTestCleared OUT varchar2<br />
)<br />
...

<br />
void SomeTest()<br />
{<br />
IDbConnection oConn = null;<br />
IDbCommand oCmd = null;<br />
IDataParameter oParam = null;<br />
IDataParameter oOutParam = null;<br />
<br />
string strTestId = null;<br />
<br />
object oReturnValRaw = null;<br />
<br />
try<br />
{<br />
strTestId = Guid.NewGuid().ToString();<br />
...<br />
oConn = DBUtil.GetDefaultDBConnection();<br />
oConn.Open();<br />
<br />
oCmd = oConn.CreateCommand();<br />
oCmd.CommandText = "spXXXXX";<br />
oCmd.CommandType = System.Data.CommandType.StoredProcedure;<br />
<br />
oParam = oCmd.CreateParameter();<br />
oParam.Value = strTestId;<br />
oParam.ParameterName = ":TestId";<br />
oParam.DbType = DbType.String;<br />
((OracleParameter) oParam).Size = strTestId.Length; // Also tried doubling size - Size = Size *2. Actually, I solved the problem by setting - oParam.Size = oCmd.CommandText.Length - what the hell...? It worked, but I have no idea why!?<br />
oParam.Direction = ParameterDirection.Input;<br />
oCmd.Parameters.Add(oParam);<br />
<br />
oOutParam = oCmd.CreateParameter();<br />
oOutParam.ParameterName = ":bAllTestCleared";<br />
oOutParam.DbType = DbType.String; // one character string, either: 'Y' or 'N'<br />
((OracleParameter) oOutParam).Size = 1;  // Also tried doubling size - Size = Size *2<br />
oOutParam.Direction = ParameterDirection.Output;<br />
oCmd.Parameters.Add(oOutParam);<br />
<br />
oCmd.ExecuteNonQuery();<br />
<br />
oReturnValRaw = oOutParam.Value;<br />
...<br />
}<br />
catch (Exception ex)<br />
{<br />
...<br />
} finally {...}<br />
}<br />

<br />
Solution<br />
> Configuration<br />
   > Configuration Manager<br />
      > Platform<br />
         > select "New"<br />
            > You can then choose x86 (32 bit) or x64 (64 bit)<br />