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 #29409 is a reply to message #29408] Tue, 19 October 2010 10:46 Go to previous messageGo to previous message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

What return to your instance the sql code:
select * from NLS_DATABASE_PARAMETERS

?
porto wrote on Tue, 19 October 2010 11:35

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.


 
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: Wed Jul 16 18:12:34 CEST 2025

Total time taken to generate the page: 0.03518 seconds