oracle 8i和9i中对BLOB字段操作的区别?
nccxl 2005-07-27 05:22:36 想请教一下,我现在有一段对oracle9i中BLOB字段操作的代码,想转成8i的操作代码。请问怎么改?
代码:
Statement stmt=null;
DbaObj.Conn.setAutoCommit(false) ;
stmt = DbaObj.Conn.createStatement();
OracleResultSet update=(OracleResultSet)stmt.executeQuery("select FileBody from Document_File where Fileid=" + String.valueOf(iFileId)+ " for update");
if (update.next()){
try{
PutAtBlob(((oracle.jdbc.OracleResultSet)update).getBLOB("FileBody"),mFileSize);
}
catch (IOException e) {
System.out.println(e.toString());
}
}
update.close();
stmt.close();