|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
