Default date conversions

[SteLal]

DOA 3.3.2 / Oracle 8.1.7 / BCB5 / French

I am changing dynamically the login propery of my unique TOracleSession.

Example: (session 's' already connected)

Before: executing "SELECT TO_CHAR(SYSDATE)FROM DUAL" -> OK

s->Connected = false;
s->Login = "NewSchema";
s->Connected = true;

After: executing "SELECT TO_CHAR(SYSDATE)FROM DUAL" -> ORA-01801

Please, any clue will help me...

 

[Marco Kalter]

What happens if you perform the equivalent actions in SQL*Plus?

------------------
Marco Kalter
Allround Automations

 

[SteLal]

I am not really sure that the problem come from TOracleSession (I suspect Oracle instead)

I've found a clean workaround to my problem:
" alter session set NLS_DATE_FORMAT = 'DD/MM/YYYY' " just after Connected = true
...and all works fine !

Thanks for replying

------------------
St