throw e;
}
catch (IOException e)
{
throw e;
}
finally {
conn.setAutoCommit(oldAutoCommit);
}
}
二、PL/SQL下
(例子表结构如一所示)
i.插入一空的Blob。
…
declare
bufferBlob BLOB;
data RAW(…)
…
INSERT INTO Student VALUES(‘zhangsan’,20 ,empty_blob() );
…
ii.更新该纪录的Blob。
…
SELECT Picture INTO bufferBlob FROM Student WHERE Name=’zhangsan’ FOR UPDATE;
DBMS_LOB.OPEN(bufferBlob ,dbms_lob.lob_readwrite);
dbms_lob.write(bufferBlob ,utl_raw.length(data) ,data);