Problem with Milliseconds

[chulett]

I've never seen that. As noted, an Oracle DATE does not support milliseconds. Which 'generation' option are you using? What version of the Oracle client is installed on your server?

[RAI ROUSES]

We are using the Oracle version 10g

The sql is generated in OCI stage, we have defined the query type :
Generated SELECT clause from column list

More strange is the fact in designer it dosen't appears the millisenconds, only :
TO_CHAR(DTARSL, 'YYYY-MM-DD HH24:MI:SS')

But when i try to do the view data or executed the job, it occcured an error of formated. And when we check the log, it appears the sql :
TO_CHAR(DTARSL, 'YYYY-MM-DD HH24:MI:SS.FF')

Any suggestion ?
merci
Rai

[chulett]

Contact your official support provider, that smells like a bug.

ps. When someone asks for an Oracle version, it means all 4 digits. Saying "10g" is way too generic, it should be more like "10.2.0.1" or some such. Some specific versions are more problematic than others.

[RAI ROUSES]

Hi all,

the problem was been solved with the inclusion of DS_NO_FF in the desenv file.

DS_NO_FF=1
export DS_NO_FF

I hope that help future similar problems


merci
Rai

[chulett]

Ah... only been mentioned a couple of other times here so not something I tend to remember. I'm not even sure it's officially documented.

[LNarayan]

the problem was been solved with the inclusion of DS_NO_FF in the desenv file.

DS_NO_FF=1
export DS_NO_FF

Hi All,

Here you have mentioned that the above statements have to be included in desenv file.

Could you please let me know this file path. hope this is not an dsenv file which is available in DSEngine category.

Thanks,

[arvind_ds]

It is dsenv in DSEngine directory itself. There is no other one.

[chulett]

FYI - It only exists on UNIX servers. As an alternative, add it as a custom environment variable via the Administrator.