Image saving problem OLEDB
I m trying to save image using following code in Oracle:
clsoperation objTrans = new clsoperation();
// clsdbhims objdbhims = new clsdbhims();
try
{
OleDbConnection objCon = new OleDbConnection();
objCon.ConnectionString = "Provider=MSDAORA; User ID = tauqeer ;Data Source=HIMS; Password=tauqeer;";
objCon.Open();
OleDbCommand insert = new OleDbCommand("insert into images([image]) values(?)",objCon );
OleDbParameter imageparm = insert.Parameters.Add("@image",OleDbType.Binary);
imageparm.Value = imge;
imageparm.Size = imge.Length;
insert.ExecuteNonQuery();
}
catch(Exception ex)
{
return ex.Message;
}
return "OK";
This code throws an exception:
"ORA-00928 missing Select keyword"
Please do help to slove this issue or give an alternate.
__________________
Regards,
Ali Irfan
|