|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Troubles with reading BLOBs |
|
From: |
Damien |
|
Date: |
8/24/2001 4:49:18 AM |
|
IP: |
212.120.161.14 |
Could anyone please help me with this problem. I cannot read BLOB field value. Database is Oracle. I use ODBC Oracle driver. The code is like the following:
BLOCK_SIZE = 4096
orRS.open "SELECT blob from table ",, adOpenDynamic
do while not orRS.eof
set fld = orRS("blob")
if fld.attributes and adFldLong then
bytesRead = 0
value = ""
size = fld.actualSize
if size=-1 then
do
data = fld.GetChunk(BLOCK_SIZE)
if isNull(data) then exit do
value = value & data
loop while LenB(data)=BLOCK_SIZE
else
do while bytesRead<size
data = fld.GetChunk(BLOCK_SIZE)
value = value & data
if isNull(data) then exit do
bytesRead = bytesRead+len(data)
loop
end if
end if
orRS.movenext
loop
orRS.close
The GetChunk Exception is raised when I am trying to read the first portion of the data. After this one of the following problem occures:
1. ASP pages stops executing. Requesting any ASP page of the application causes browser to wait a long time and report no error, as well as to display nothing.
2. No ADODB.RecordSet objects can be created - "Error creating object" error occures, though Connection or Command objects are creating ok. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
