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 |
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
|
|
|
|
|
A trouble with "select" from Oracle DB
By: porto on Mon, 18 October 2010 15:52
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 09:28
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 09:43
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 10:02
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 10:35
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 10:46
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 10:53
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 11:33
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 13:15
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 13:35
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 13:53
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 14:28
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 14:44
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 15:15
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 15:34
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 16:21
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 16:31
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Tue, 19 October 2010 17:00
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Tue, 19 October 2010 17:14
|
|
|
Re: A trouble with "select" from Oracle DB
By: tojocky on Wed, 20 October 2010 09:15
|
|
|
Re: A trouble with "select" from Oracle DB
By: porto on Wed, 20 October 2010 09:54
|
Goto Forum:
Current Time: Thu May 16 04:50:32 CEST 2024
Total time taken to generate the page: 0.02519 seconds
|