Re: Different date formats between thin and thick clients
- From: Neil Chandler <neil_chandler@xxxxxxxxxxx>
- To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>
- Date: Mon, 21 Feb 2011 21:29:29 +0000
Sandra,
Would it not be possible to set the environment variable NLS_DATE_FORMAT on
each client?
Regards
Neil Chandler
sent from my phone
On 21 Feb 2011, at 19:04, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:
>
> | using oci 9.2 | using thin
> NLS_DATE_FORMAT | Mon DD YYYY HH24:MI:SS | DD-MON-RR
>
>
> Our latest brainstorm produced the following plan:
>
> 1. Create a new database user to be used by ONLY the piece of the
> application that is currently broken. This piece of the app has only 1
> function, a very limited scope.
> 2. Create an after logon trigger for the new userid to correctly set the
> date format.
> 3. Make the necessary application configuration changes to login to the
> database with the new userid.
> 4. Test, test, test, and test again.
>
> Does anyone see any problems with this approach or any suggestions?
>
> --
> Sandy
> Transzap, Inc.
Other related posts:
