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
Try different decimal separators ('.' or ',' or none) in Windows Regional Settings.
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;