No replies to this topic

[royvb]

Hi All,
i have a code below and wanted ur help regarding the red line. is it correct declaration?

public void writeDataWithCommand()
{
FileInfo fi = new FileInfo("c:/Test.txt");
StreamReader sr = new StreamReader(fi.FullName);
String tempBuff = sr.ReadToEnd();
sr.Close();

using (OracleConnection conn = new OracleConnection("User Id=xxx;Password=xxx;Data Source=xxxx"))
{

conn.Open();
Console.WriteLine("Connected...");
String strSQL = "INSERT INTO BANK_WITHDRAWAL_REQUEST (PACKAGE,CARD_TYPE,BANK_FACILITY, BANK_BNR,PRE_BANK_FACILITY,PRE_BANK_BNR,DB_FACILITY,DB_BNR, CARD_LEVEL,NO_OF_CARD, REQUESTED_QTY) VALUES (TO220,:TEXT_DATA) ";
OracleParameter parmData = new OracleParameter();
parmData.Direction = ParameterDirection.Input;
parmData.OracleType = OracleType.Clob;
parmData.ParameterName = "TEXT_DATA";
parmData.Value = tempBuff;


OracleCommand cm = new OracleCommand();
cm.Connection = conn;
cm.Parameters.Add(parmData);
cm.CommandText = strSQL;
cm.ExecuteNonQuery();

conn.Close();

}

Console.WriteLine("Done!");

}