I believe When ORA-00904 occurs, you must enter a valid column name as it is either missing or the one entered is invalid. The "invalid identifier" most common happens when you are referencing an invalid alias in a *select* statement.
What happens when you look at the t table structure for T740 Desc t740 Does this list the column C536870919? Also, when you run below query from db, does it work Select C536870919 from t740; Can you enable SQL log and paste the snippet of logs when you click on that drop down list. Regards/Vaibhav On Friday, February 8, 2013, Nau, Michael wrote: > ** > > Hi List, here’s some error I encountered this morning:**** > > ** ** > > We have a custom form – display-only, just a customized view of the data > on TMS:Task. The form hasn’t been touched in years. It’s so old, I don’t > even know if anyone has ever opened it in the webclient. On it, there is a > menu to select a support group and a drop-down list to select a task > status. When the users changes on of these two fields, a table showing the > tasks is refreshed, using the selected values as EXTERNAL qualifications. > Works without any problems on the User Tool.**** > > ** ** > > Now…on the webclient the form takes unusually long to load. The table is > not showing, not at all, not even the header / footer. Now it gets really > interesting: When the user selects a status from the drop-down list, > ORA-00904 is raised, pointing to "T740"."C536870919", and ARWARN 311. This > is the drop-down list itself.**** > > ** ** > > What I’ve done: **** > > - flushed cache**** > > - restarted midtier**** > > - checked the form and all field names for characters the midtier could > trip over**** > > - renamed the drop-down list and the table**** > > ** ** > > ** ** > > AR 7.0.0.1 / Solaris / Oracle 11gR2**** > > MidTier 7.5.00 7 RHEL / tomcat 5.5.32**** > > ** ** > > ** ** > > Have a nice weekend,**** > > Michael Nau**** > > ** ** > > IT Infrastructure & Customer Services**** > > ING-DiBa AG**** > > Theodor-Heuss-Allee 100**** > > 60486 Frankfurt am Main**** > > Telefon 069 / 27 222 66596**** > > [email protected] <javascript:_e({}, 'cvml', '[email protected]');>**** > > www.ing-diba.de**** > > ** ** > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Sent from Gmail Mobile _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
