If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Contributor Publish Locale Problem (Oracle)

Started by chriso, 04 Feb 2007 05:15:09 PM

Previous topic - Next topic

chriso

Hi, any hints on how to publish with local locale settings?
We're running Contributor over Ora 10g. Publish cancells in a mid way, and the bulk loader indicates dec separators as the problem. The oracle locale is Polish (win1250). It's the Customer corp. policy to have it set to local.
Looking for help, perhaps you had similar cases. I've seen Zeeuw talking about locale in context of importing data (on another thread).

cheers,
/chriso

ykud

Try different decimal separators ('.' or ',' or none) in Windows Regional Settings.

chriso

Hi Void, thanks for the hint. We finally made it and the publish works by nowÃ,  ;D
If ever interested this piece of code might help sometimes,...
cheers,
/chriso

CREATE OR REPLACE TRIGGER alter_session_nls
AFTER LOGON ON DATABASE
BEGIN

select program from v$session where
audsid=sys_context('userenv','sessionid');

if the program column returns 'sqlloader' (or sqlloader.exe)
execute immediate 'alter session set nls_numeric_characters= '' ,'' '

END alter_session_nls;