Changing the length of a character field from <= 4000 to > 4000 characters on Oracle changes the data type from a varchar to a clob.
Can you post the sql logs that lead up to the error? Probably 3 lines leading up to the error will be enough. ORA-00904 seems to be unrelated, but the logs should make it evident what the problem is. Axton Grams On 9/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I have looked at the logs and its telling me that the error is coming > from one specific ticket. But the error will repeat again on a brand > new ticket. The user is showing up as AR_Escalator and I'm not sure > if that is significant. The ORA-00932 error is stating "Failure > during SQL Operation to the database: ORA-00932 inconsistant datatype > expected -got CLOB" > > I'm trying to work with the Oracle guys but they are just as lost as I > am on this issue. All because the other admin changed the datatype > on the fields property to 0. > > On Sep 28, 11:23 am, Howard Richter <[EMAIL PROTECTED]> wrote: > > Axton, > > > > As always is correct, turn on sql and api logs, that might pin it down. > > > > hbr > > > > On 9/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > Hello All, > > > > > I am trying to fix a problem with the Solution Summary field on the > > > Helpdesk form. The admin before thought he could make that field > > > unlimited characters so he set the data input length to 0 under the > > > database tab on field properties. Since he did that, he cannot use > > > that field or the possible solutions button. We now get an ORA-00932 > > > error. > > > > > So I decided to duplicate the problem on the test server and see if I > > > could delete the field and recreate it. I imported the good bad > > > helpdesk form onto the test server. I tried to delete the field but > > > it will not let me. So then I just hid the field and created a new > > > one. When I save the form, on the admin tool it shows that its saves, > > > but it only did it on one view regardless that its set to go on all > > > views. I made the changes again on each individual form and it saves > > > somewhat reluctantly. Well when I open the helpdesk form on the user > > > client it doesnt' show the change. > > > > > When I look in the ARERRR.log, I show a bunch of errors that state " > > > Failure during SQL opreation on the database (ARERR 552) ORA-00904: > > > C12312312: invalid identifier" errors for serveral fields on the > > > helpdesk form. It seems as if the Oracle database and the Remedy > > > server are not connecting correctly. I just can't figure out how to > > > fix this now. > > > > > Any help or advice? > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > > > the Answers Are" > > > > -- > > Howard Richter > > > > Remedy ServiceDesk Manager > > CedarCrestone Managed Services Center > > > > [EMAIL PROTECTED] > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > > Answers Are"- Hide quoted text - > > > > - Show quoted text - > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
