Search code examples
oraclesqr

fetched column value was truncated error in SQR File

We are having one SQR file. When I execute that SQR,I got below error.

SQR 5528) ORACLE OCIStmtFetch error 1406 in cursor 1:
   ORA-01406: fetched column value was truncated

Error on line 565:
   (SQR 3725) Bad return fetching row from database.

It usually runs well. As far as I investigate I able to find in which SP it throws error.

But problem is that I couldn't find how to change select statement in SQR file to normal sql select statement which can be executed in Toad. My SP has 3 select statement(union all).

Can anybody know what may be the cause of the issue. It will be very helpful if anybody tell me the way to quickly change the select or how to run that SQR in toad.

Solution

  • As I investigate further one of customer have '¿' this special character in his name which is the reason for error. After updating customer name report generated successfully.