oracle8i和oracle9i客户端对二进制流的处理方式不一样了么?Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "image/gif"
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase("SERVERNAME","uid/pwd", Cint(0))mysql="select PIC from TB ...."
Set OraDynaset = OraDatabase.DbCreateDynaset(mysql, cint(0))
set PartImage = OraDynaset.Fields("PIC").Value
amount_read = PartImage.Read(buffer)
以上语句在oracle8i的客户端下可以正确显示图片,怎么在oracle9i客户端无法显示图片呢?
Response.Binarywrite buffer
Set OraSession=nothing
Response.End
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "image/gif"
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase("SERVERNAME","uid/pwd", Cint(0))mysql="select PIC from TB ...."
Set OraDynaset = OraDatabase.DbCreateDynaset(mysql, cint(0))
set PartImage = OraDynaset.Fields("PIC").Value
amount_read = PartImage.Read(buffer)
以上语句在oracle8i的客户端下可以正确显示图片,怎么在oracle9i客户端无法显示图片呢?
Response.Binarywrite buffer
Set OraSession=nothing
Response.End
解决方案 »
- ExtJs 中的DateField组件 不能在ie下使用 谁知道应该怎么做
- 存储过程优化---千万级数量..谢谢
- ORACLE 10G 登录很慢,检索也慢.不知是何原因,数据量不大.
- 安装了Oracle10g后是不是要配置?
- 请教:多表(9个)联合查询语句怎么写?
- oracle中如何创建自己的方案
- 请大家们看我错在哪里了????
- 请问如何在存储过程中调用其它的存储过程?
- 用什么方法可以查到表空间(如USERDATA)上有哪些表?
- 在win2k server下为什么装不上ORACLE8.1.7,是p4的机子!高分在线等待!
- Oracle10数据库中为啥空字符串总自动变成个null值?
- 过程 结果集 几个问题!?
On Error Resume Next
Response.Expires = 0' Clear out the existing HTTP header information
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "image/jpg"' Change the HTTP header to reflect that an image is being passed. Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=OraOLEDB.Oracle;Data Source="&session("ora_sid")&";User ID="&session("ora_user")&";PASSWORD="&session("ora_pwd")&";Persist Security Info=True" Set txrs = cn.Execute("SELECT 图象数据 FROM "&session("cktx")&" where 公民身份号码='"&session("sfzh")&"'")
Response.BinaryWrite txrs("图象数据")
set txrs=nothing
set cn=nothing
Response.End %>
在其它页面需要的地方写<IMG SRC="SHOWIMG.ASP" width="135" height="160">就行了.