LOBs and ORA-03127 error

[Greg Stevenson]

Came accross an issue that exists in at least Versions 3.4.6.1 and 4.0.6.2. This is the scenario I see via the Oracle Monitor. I do a select (in a series of queries) where one or more of the columns contain lobs. The select returns with X rows, but apparently the lob fetches occur asychonously after the orginal select and some other querys occur between LOB fetches. However, one query occurs after the fetch of a big lob starts and I get the ORA-03127 error. Is there a way synchronize with LOB fetches so this does not occur?
--Greg

 

[Marco Kalter]

Are you perhaps using a multi-byte character set? If so, do you have TOracleSession.BytesPerCharacter set to bcAutoDetect?