0 Replies Latest reply: Apr 28, 2010 6:51 AM by 745247 RSS

    OO4O, ASP and CLOB

    745247
      Hello Together,

      i have a problem with this function in ASP:

      function chunkText(str)
      '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
      exit do
      end if
      nChunkLast = len(sChunk)
      finalString = finalString & sChunk
      iX = iX + 1
      loop
      chunkText = finalString
      end function

      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
      correct.

      Why I got only 1 and not 4 INACTIVE DB-Session?
      Can anyone help me?

      Best Regards

      Andy