Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DPI Error: DPI-1037: column at array position fetched with error 1406 #3

Closed
madmaxio opened this issue Mar 19, 2018 · 4 comments
Closed
Labels

Comments

@madmaxio
Copy link

Getting this while doing select, I beleive it is :

ORA-01406: fetched column value was truncated
Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.
Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing. 

Any ideas how to fix?

@kubo
Copy link
Owner

kubo commented Mar 19, 2018

@madmaxio I have not seen such error. Could you post the following information?

  • Sample code to reproduce the issue
  • The table definition. Run desc TABLE_NAME on sqlplus.
  • The database NLS character set. Run select value from nls_database_parameters where parameter='NLS_CHARACTERSET'; on sqlplus.

@kubo
Copy link
Owner

kubo commented Mar 19, 2018

I reproduced it. You have no need to post the information I requested.

kubo added a commit that referenced this issue Mar 19, 2018
… 1406`

when a column value converted from the database character set to UTF-8
becomes longer than the column size.
See #3
@kubo
Copy link
Owner

kubo commented Mar 19, 2018

I think that this issue was fixed by 2e00b3a. Could you try it using the following Cargo.toml?

[dependencies]
oracle = { git = "https://github.com/kubo/rust-oracle.git" }

@madmaxio
Copy link
Author

Worked! Thx.

@kubo kubo added the bug label Jun 28, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants