CREATE TABLE TEST (BLOB LONG, ID NUMBER)SQL 語句長度限制(通常 64KB),無法直接 INSERT/UPDATE 超大文本。需使用 Recordset 分塊讀寫方法。
test.asp<%
If Request("ok") = "1" Then
' 字符預處理
Function tansstr(sstr)
sstr = Replace(sstr, " ", " ")
sstr = Replace(sstr, Chr(13) & Chr(10), "<br>")
tansstr = sstr
End Function
c = tansstr(Request("text"))
' 連接
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("autop", "system/manager", 0)
Set rs = OraDatabase.CreateDynaset("select * from test order by id desc", 0)
' 計算新 ID
If rs.EOF Then id = 1 Else id = rs("id") + 1
' 關鍵:分塊寫入
rs.DbAddNew
rs.Fields("blob").DbAppendChunk c ' 核心方法
rs("id") = id
rs.DbUpdate
' 顯示結果並關閉
...
End If
%>
<html><body>
<form method="POST" action="test.asp">
<textarea name="text" rows="13" cols="104"></textarea><br>
<input type="submit" value="存入">
<input type="hidden" name="ok" value="1">
</form>
</body></html>
view.asp<%
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("autop", "system/manager", 0)
Set Rs = OraDatabase.DbCreateDynaset("select * from test order by id desc", 4) ' 4=adLockReadOnly
Size = 65280 ' 64KB 塊大小
I = 0
Do
Text = Rs.Fields("Blob").DbGetChunk(I * Size, Size) ' 核心方法
Response.Write Text
If LenB(Text) < Size Then Exit Do
I = I + 1
Loop
Set OraSession = Nothing
%>
DbAppendChunk(data):向 LONG/LOB 字段追加二進制/字符數據。DbGetChunk(offset, size):從指定偏移讀取指定字節數。Oracle 9i+ 建議改用 CLOB/BLOB 類型配合 DBMS_LOB 包或 ODP.NET 托管訪問,性能與功能更強。