'Chunks Text coming from a NCLOB in several parts and puts them into one string
dim iX, sChunk, nChunkSize, nChunkLast, finalString
iX = 0
sChunk = ""
nChunkSize = 10240
nChunkLast = 0
finalString = ""
do while nChunkLast < nChunkSize
sChunk = str.GetChunk(iX * nChunkSize, nChunkSize)
if sChunk = "" then
Set str = nothing
nChunkLast = len(sChunk)
finalString = finalString & sChunk
iX = iX + 1
chunkText = finalString
the problem I have is that this function works fine,
but 1 from 4 calls of the functions 1 DB-Session is
in Oracle as INACTIVE, and I Don´t know why,
because i close and than I destroy the object in ASP
Why I got only 1 and not 4 INACTIVE DB-Session?
Can anyone help me?