大家好,请问大家一个问题,
我用delphi开发环境,数据库oracle请问我要把图片相保存在数据库,我怎么实现啊。。我在线等后,谢谢!!!!!!!
我用delphi开发环境,数据库oracle请问我要把图片相保存在数据库,我怎么实现啊。。我在线等后,谢谢!!!!!!!
解决方案 »
- 在PLSQL里写存储过程中怎么传参数
- OracleTypes.CURSOR在java的jdbc驱动中中对应的是什么类型??
- Oracle中如何分隔字符串?
- 求教,我想从所有表中查一个数据怎么办?
- oracle数据库启动问题:ERROR:ORA-01033: ORACLE initialization or shutdown in progress
- Oracle9i中导入数据表时发生错误ORA-01658
- 请大虾帮忙!越快越好!谢谢了!
- 紧急问题。请教!谢谢。
- 怎么恢复
- 有用过Oracle InProc Server的吗?
- 想實現一種功能,怎樣用sql 語法實現!!
- 请教一个关于imp的问题,高手,低手都可以发表一下意见
Dim PartDesc As OraClob
Dim buffer As String
Dim ChunkSize As Long
Dim amount_written As Long
Set PartDesc = Fd.Value
ChunkSize = 1000
buffer = String$(ChunkSize, 32)
Open FileName For Binary As #1
PartDesc.offset = 1
PartDesc.PollingAmount = LOF(1)
remainder = LOF(1)
Get #1, , buffer
amount_written = PartDesc.Write(buffer, ChunkSize, ORALOB_FIRST_PIECE)
While PartDesc.Status = ORALOB_NEED_DATA
remainder = remainder - ChunkSize
If remainder < ChunkSize Then
piecetype = ORALOB_LAST_PIECE
ChunkSize = remainder
buffer = String$(ChunkSize, 32)
Else
piecetype = ORALOB_NEXT_PIECE
End If
Get #1, , buffer
amount_written = PartDesc.Write(buffer, ChunkSize, piecetype)
Wend
Close #1
End Sub
db.Open "Provider=msdaora;Password=adminpass;Persist Security Info=True;User ID=admin;Data Source=hd.sj"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select 编号,身份号码,图象数据 from TX", db, adOpenStatic, adLockOptimistic因为"图象数据"是BLOB类型,adoPrimaryRS.Open总是报错但以前存图像的字体段是LONG类型就行的.不知应如何对这种ORACLE新推的字段类型操作.