Devart Forums

Hi Folks!

It looks like there is a problem with FieldsAsString and the buffer size used to return dates when changes are made to NLS_DATE_FORMAT. Here's an example of what happens:
Note that the size of the date string stays the same and truncates the string. Perhaps I'm missing a setting or call I can make to reset the buffer size? Thanks for any help or suggestions!

-Mark Ford
Benthic Software

ODAC reads the value of NLS_DATE_FORMAT one time at connecting or later. When you change NLS_DATE_FORMAT with ALTER SESSION, ODAC does not reread the value.

There is no special method to reset the settings stored in TOraSession component. But you can change the value of CharLength or Charset options to reset settings.

Hi Plash,

This means that I have to scan each statement and reset CharLength after any call that alters NLS_DATE_FORMAT. Will this be a problem in a multi-threaded environment where background threads are running queries of that session? I'm concerned that doing this will cause problems.

This is actually a pretty big deal since programs that would tend to use the FieldsAsString setting would also tend to use "alter session" to change the NLS_DATE_FORMAT (at least in my experience.)

Thanks for any help.

-Mark

To avoid the problem, DateFormat option of TOraSession should be used instead of ALTER SESSION.

Unfortunately that's not really an option in this case. The only real solution that I've found is to modify the source code to use a larger fixed buffer for the date string. Obviously this means a larger record buffer overall, but I don't seem to have any choice.

-Mark