Thanks for the suggestion, Fred, but it is only putting a 11-char value into a 255 char field.
I found that if I did an unqualified search on the "Read Value for Field From:" form I got the same error. So there must be a bad record in the form. I also found a problem in my "Set Field If:" selection, and when I changed it the problem went away. So I think I was trying to select a bad record that I didn't really want anyway. Dwayne Martin ---- Original message ---- >Date: Tue, 30 Oct 2007 15:21:25 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: ORA-01406 SQL error in Active Link >To: [email protected] > >Since it is a column value that is truncated, what is the size of the >data and the size of the fields you are putting them into? Did someone >change the size of a field on either form? > >C1,C2,C561000203,C8 > >Fred > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, October 30, 2007 3:05 PM >To: [email protected] >Subject: ORA-01406 SQL error in Active Link > >Hello Everyone, > >I am getting an error in an Active Link that says, > >"ARERR [552] Failure during SQL operation to the database : ORA-01406: >fetched column value was truncated." > >This happens during a Set Fields operation where it is reading a value >from another form. The Set Field is very similar to a dozen others that >work, and it was working till just now. > >I ran an SQL log, and the SQL statement is > >":SELECT T570.C1,C2,C561000203,C8 FROM T570 WHERE ((T570.C561000214 != >'PIQ00120') AND (T570.C1 != 'ITRS0003037') AND (T570.C561000257 != >'Cancelled')) ORDER BY 1 DESC" > >followed by the same error message. > >But I can paste that very same SQL statement into TOAD, and it brings >back a result set. > >I tried the Support Knowledge base, but the one entry referred to >retrieving an attachment and the other to flashboards. > >Any idea what is going on? > >(ARS 7.1, RH Linux server, Oracle 10.2 db) > >Dwayne Martin >James Madison University > >Dwayne Martin >Computing Support >James Madison University > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the >Answers Are" Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
