如何用ASP中读取ORACLE的BLOB字段中的图片

[241219]

图片已经存了在oracle数据中,现在要读取出来,不知道大家有什么办法?

分不够可以再加,谢谢了.

[241219]

我用过这种方法,不行:
<%
id=request("id")
Response.Expires=0
Response.Buffer = true
Response.Clear
Response.ContentType = "image/jpeg" '关键的代码，传送走的文件类型在此指定，
SQL = "select * from picture where id="& id
Rs.Open SQL,Conn,3
Response.BinaryWrite Rs("Lpic") '关键的代码，图片靠此语句显示
Rs.Close
Set Rs = Nothing
%>

[cnchart]

Response.ContentType = "image/jpg"
Response.AddHeader "Content-Disposition", "attachment;filename=test.jpg"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=OraOLEDB.Oracle.1;Data Source=oradb;","user","pwd"
set rs=server.createObject("ADODB.Recordset")
sql="select img,no from sp_tb where no='9937'"
rs.open sql,conn,1,1
Response.BinaryWrite(rs("img"))

测试平台
oracle10g+win2003+IIS6
img是blob字段