determining and setting decimal separator

From: CMa <marek.cwiklinski_at_microgen.pl>
Date: 20 Jan 2005 07:30:39 -0800
Message-ID: <1106235039.073810.31540@z14g2000cwz.googlegroups.com>

Hi,

1. I've some numeric data stored as the strings with dot (.) as decimal separator and I use OCI Direct Path functionality to write it to the Oracle database. Please let me know, how to determine and change decimal separator for loading data using Direct Path?
2. How to set OCI_NLS_DECIMAL using any (which one ?) OCI function, instead of executing SQL statement: "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'"

Regards,
Marek Received on Thu Jan 20 2005 - 09:30:39 CST