求C#读写oracle数据库中clob数据的代码
如题,求C#中操作oracle数据库中clob类型数据的相关代码,第一次接触,一点也不会啊,不知道如何写,给点参考代码,谢了
帮你顶一下
string file_name = this.filepath1_txt.Text.ToString();//图片路径
Bitmap bmp = new Bitmap(file_name);
FileInfo fi = new FileInfo(file_name);
int w = bmp.Width;//宽
int h = bmp.Height;//高
long s = fi.Length;
string conn_str = "Provider=OraOLEDB.Oracle.1;Password=123;Persist Security Info=True;User ID=123;Data Source=123;Extended Properties=";
OleDbConnection cn = new OleDbConnection(conn_str);
cn.Open();
OleDbCommand cmd;
cmd = new OleDbCommand("insert into Table_1(fphoto) values(:FPHOTO1)", cn);
cmd.Parameters.Add("FPHOTO", OleDbType.Binary);
FileStream fs = new FileStream(file_name, FileMode.OpenOrCreate, FileAccess.Read);
byte[] MyData = new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
cmd.Parameters["FPHOTO"].Value = MyData;
int result = cmd.ExecuteNonQuery();
if (result >
相关问答:
在执行包的时候引用oracle spatial空间函数出错,出错情况如下
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
假设table01 中有 以下资料
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
常用电话
而我们要得到以下的OUTPUT (或是各种其他的output)
0001,TOM
0002,JOHN
......
oracle 11g 安装 01092 错误,
日志信息:
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......