Re: Different date formats between thin and thick clients

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_at_gmail.com> 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.

--
http://www.freelists.org/webpage/oracle-l