private void AddedOutputParamater(OracleCommand voDBComm, string vsParameterName,
Oracle.DataAccess.Client.OracleDbType voOracleType, int vsLength)
{
voDBComm.Parameters.AddRange(new Oracle.DataAccess.Client.OracleParameter[] {
new Oracle.DataAccess.Client.OracleParameter(vsParameterName, voOracleType, vsLength,
System.Data.ParameterDirection.Output, true, 0,
0, "", System.Data.DataRowVersion.Current, null)
});
}
private void CreateOracleParameter(IDbCommand command, OracleDataAccessClient.OracleCommand commandNew)
{
foreach (OracleParameter para in command.Parameters)
{
OracleDataAccessClient.OracleDbType oracleType = ConvertOracleType(para.OracleType);
OracleDataAccessClient.OracleParameter paraNew = new OracleDataAccessClient.OracleParameter(para.ParameterName, oracleType);
paraNew.Value = para.Value;
commandNew.Parameters.Add(paraNew);
}
}
private void AddedInputParamater(OracleCommand voDBCommand,
String sParameterName,
Object voValue,
Oracle.DataAccess.Client.OracleDbType oOracleType)
{
voDBCommand.Parameters.AddRange(new Oracle.DataAccess.Client.OracleParameter[] {
new Oracle.DataAccess.Client.OracleParameter(sParameterName, oOracleType)
});
voDBCommand.Parameters[sParameterName].Value = voValue;
}
void GetOracleDbType(cOracle._OracleDbType pOracleDbType, ref Oracle.DataAccess.Client.OracleDbType pDAOracleDbType)
{
if (pOracleDbType == _OracleDbType.OraByte)
{
pDAOracleDbType = OracleDbType.Byte;
}
else if (pOracleDbType == _OracleDbType.OraBlob)
{
pDAOracleDbType = OracleDbType.Blob;
}
else if (pOracleDbType == _OracleDbType.OraDate)
{
pDAOracleDbType = OracleDbType.Date;
}
else if (pOracleDbType == _OracleDbType.OraDecimal)
{
pDAOracleDbType = OracleDbType.Decimal;
}
else if (pOracleDbType == _OracleDbType.OraDouble)
{
pDAOracleDbType = OracleDbType.Double;
}
else if (pOracleDbType == _OracleDbType.OraInt16)
{
pDAOracleDbType = OracleDbType.Int16;
}
else if (pOracleDbType == _OracleDbType.OraInt32)
{
pDAOracleDbType = OracleDbType.Int32;
}
else if (pOracleDbType == _OracleDbType.OraInt64)
{
pDAOracleDbType = OracleDbType.Int64;
}
else if (pOracleDbType == _OracleDbType.OraLong)
{
pDAOracleDbType = OracleDbType.Long;
}
else if (pOracleDbType == _OracleDbType.OraSingle)
{
pDAOracleDbType = OracleDbType.Single;
}
else if (pOracleDbType == _OracleDbType.OraVarchar2)
{
pDAOracleDbType = OracleDbType.Varchar2;
}
}