Re: How to use "alter session ..." with Oracle JDBC.
Thursday, January 8, 2009 06:11 PM
I had the same question and came across your post ... I later found an answer (it worked for me anyway).
In short (from what I now psuedo understand) - this will not ever work. Java sidesteps the Oracle formatting when it retrieves the data.
There is a work around. If you do a:
select to_char(field_name) from ....
Then Oracle will use the session data you set to format the string before Java ever accesses it.
Hope that helps.