public static OracleLob CreateTemporaryLobLocator (OracleCommand cmd, OracleType lobType)
{
cmd.CommandText =
"DECLARE TEMP_LOB " + lobType.ToString () + "; " +
" BEGIN " +
" SYS.DBMS_LOB.CREATETEMPORARY (TEMP_LOB, FALSE); " +
" :TempLobLocator := TEMP_LOB; " +
" END;";
OracleParameter parm = cmd.Parameters.Add ("TempLobLocator", lobType);
parm.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery ();
return (OracleLob)parm.Value;
}
internal static Exception BadBindValueType(Type valueType, OracleType oracleType)
{
return InvalidCast(System.Data.OracleClient.Res.GetString("ADP_BadBindValueType", new object[] { valueType.ToString(), oracleType.ToString() }));
}
internal static Exception InvalidLobType(OracleType oracleType)
{
return InvalidOperation(System.Data.OracleClient.Res.GetString("ADP_InvalidLobType", new object[] { oracleType.ToString() }));
}
internal static Exception InvalidOracleType(OracleType oracleType)
{
return ArgumentOutOfRange("oracleType", System.Data.OracleClient.Res.GetString("ADP_InvalidOracleType", new object[] { oracleType.ToString() }));
}
internal static Exception UnsupportedOracleDateTimeBinding(OracleType dtType)
{
return ArgumentOutOfRange("", System.Data.OracleClient.Res.GetString("ADP_BadBindValueType", new object[] { typeof(OracleDateTime).ToString(), dtType.ToString() }));
}
