I have a data defined by NUMBER(38,3) ,for example 123456789012345678901234567890, I get the col width is 22 by OCI_GetColumnSize , and fmt set the default "FM99999999999999999999999999999999999990.999999999999999999999999" ,when I use Direct Path Load --OCI_DirPathSetColumn(dp, i, (const char )col_meta[i].colname, col_meta[i].colwidth, (const char )col_meta[i].fmtstr);, the data turn out be 1234567890123456789012
Can anyone tell me what's the problem?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "OCILIB troubleshooting (ReadOnly - Use GitHub tracker instead)" comments posted by this user
Mark all as spam, and block user from posting to "Old Discussions [ReadOnly]"
I have a data defined by NUMBER(38,3) ,for example 123456789012345678901234567890, I get the col width is 22 by OCI_GetColumnSize , and fmt set the default "FM99999999999999999999999999999999999990.999999999999999999999999" ,when I use Direct Path Load --OCI_DirPathSetColumn(dp, i, (const char )col_meta[i].colname, col_meta[i].colwidth, (const char )col_meta[i].fmtstr);, the data turn out be 1234567890123456789012
Can anyone tell me what's the problem?
Hi,
OCILIB has moved to GitHub.
Please, use the Git tracker for new issues/questions :)
Thanks
Vincent
View and moderate all "OCILIB troubleshooting (ReadOnly - Use GitHub tracker instead)" comments posted by this user
Mark all as spam, and block user from posting to "Old Discussions [ReadOnly]"
I found the answer , oracle instantclient_11_2/sdk/include file orl.h : #define OCI_NUMBER_SIZE 22
I changed 22 to 38, then ok. Thank you!