Dear List, We have a form that we have been using for years, but when I try to do a unqualified search I get ": ORA-01406: fetched column value was truncated." The sql log shows the same message, but no indication of what is causing it. The sql log selection statement is: SELECT * FROM ( SELECT T570.C1,C2,C561000257,C561000214,C8 FROM T570 ORDER BY 1 ASC ) WHERE ROWNUM <= 2147483648. I can paste this statement into SQL Developer, and it runs with no problem. I can open individual entries with no problem, but somewhere there must be a problem entry. How can I track it down? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

