Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » Community » Newbie corner » A trouble with "select" from Oracle DB
Re: A trouble with "select" from Oracle DB [message #29408 is a reply to message #29405] Tue, 19 October 2010 10:35 Go to previous messageGo to previous message
porto is currently offline  porto
Messages: 51
Registered: March 2007
Member
The client applications works without problems (I did not developed them). If there is a problem in the database itself, I can not fix it, because it's a big database of state organization. Therefore, correction of the database itself is impossible. Especially since all the software if this organization works with the DB without problems.

I think the problem is not the number of rows, but that is columns of some rows have to large values (text values in my case have 255 unicode characters maximum) that do not fit in the some buffer, which must be increased. Encountering a value greater than the buffer size, the fetching is terminated.
I quote again from the error log:
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.

[Updated on: Tue, 19 October 2010 10:36]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message icon7.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: tar library for u++
Next Topic: Maybe stupid qustions for UPP developers...
Goto Forum:
  


Current Time: Thu May 16 04:50:32 CEST 2024

Total time taken to generate the page: 0.02519 seconds