Forum OpenACS Q&A: Re: Response to Read CLOB from Oracle into Tcl?

Collapse
5: Re: Response to Read CLOB from Oracle into Tcl? (response to 4)
Posted by Ryan Gallimore on 05/29/12 03:23 PM
Don, can you clarify how to read clobs like varchars? to_char(v_clob) would not be able to handle anything greater than 4000 chars.
Collapse
6: Re: Response to Read CLOB from Oracle into Tcl? (response to 5)
Posted by Jeff Rogers on 05/29/12 08:45 PM
IIRC, the oracle driver recognizes clob locators in the select result and issues the appropriate OCI calls under the covers to fetch the lob. So a plain ordinary select including a lob column should just work.

The only catch is that there ends up being an extra roundtrip to the oracle server for each locator, i.e., probably each row, which can be very slow compared to to_char(lob) or dbms_lob.substr(lob)

Collapse
7: Re: Response to Read CLOB from Oracle into Tcl? (response to 6)
Posted by Ryan Gallimore on 05/30/12 12:29 AM
I fixed the problem of reading back a large clob by changing the LobBufferSize in my config.tcl to 500000.