issue with ole2.get_char_property - urgent
Posted on 2004-10-17
I'm using ole2.get_char_property function for loading data from excel to oracle.
In spreadsheet some cell has a numeric values while they still needs to be treated as character for Oracle varchar2 data type.
It seems like this function takes the first byte only for numeric value????
cell values : 12345 --> 1
23456 --> 2
Since the same column can have character and numeric value how can I deal with this issue?