Re: forms passing where clause to reports and 904 error

Both the c/s and web tests are being done to the same DB. With c/s it works, with web it fails.

"Ryan" <rgaffuri_at_cox.net> wrote in message news:smdaa.161242$4F3.10278465_at_news2.east.cox.net...
> Im willing to bet your looking in the wrong place. Are you absolutely
> positively certain your getting a correct column passed to you? Are you on
> the same database?
>
> Check there first....
>
>
> "Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message
> news:KF1aa.5892$J51.1230306_at_news1.news.adelphia.net...
> > Oracle:
> > Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.2.0 - Production
> >
> > Forms:
> > Forms [32 Bit] Version 6.0.8.11.3 (Production)
> > Oracle Toolkit Version 6.0.5.35.0 (Production)
> > PL/SQL Version 8.0.6.0.0 (Production)
> > Oracle Procedure Builder V6.0.8.11.0 Build #449 - Production
> > PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
> > Oracle Query Builder 6.0.7.0.0 - Production
> > Oracle Virtual Graphics System Version 6.0.5.35.0 (Production)
> > Oracle Tools GUI Utilities Version 6.0.5.35.0 (Production)
> > Oracle Multimedia Version 6.0.5.34.0 (Production)
> > Oracle Tools Integration Version 6.0.8.10.2 (Production)
> > Oracle Tools Common Area Version 6.0.5.32.1
> > Oracle CORE Version 4.0.6.0.0 - Production
> >
> > Reports:
> > Report Builder 6.0.8.11.3
> > ORACLE Server Release 8.0.6.0.0
> > Oracle Procedure Builder 6.0.8.11.0
> > Oracle ORACLE PL/SQL V8.0.6.0.0 - Production
> > Oracle CORE Version 4.0.6.0.0 - Production
> > Oracle Tools Integration Services 6.0.8.10.2
> > Oracle Tools Common Area 6.0.5.32.1
> > Oracle Toolkit 2 for Windows 32-bit platforms 6.0.5.35.0
> > Resource Object Store 6.0.5.0.1
> > Oracle Help 6.0.5.35.0
> > Oracle Sqlmgr 6.0.8.11.3
> > Oracle Query Builder 6.0.7.0.0 - Production
> > PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
> > Oracle ZRC 6.0.8.11.3
> > Oracle Express 6.0.8.3.5
> > Oracle XML Parser 1.0.2.1.0 Production
> > Oracle Virtual Graphics System 6.0.5.35.0
> > Oracle Image 6.0.5.34.0
> > Oracle Multimedia Widget 6.0.5.34.0
> > Oracle Tools GUI Utilities 6.0.5.35.0
> >
> > Problem:
> > The Report constructs a where clause that is passed to the report.
Running
> > the two as C/S works just fine and the report is produced. But running
the
> > same as Web causes an ORA-00904. And, it isn't like this is the only
> > Form/Report combination, we have many others that run just fine.
> >
> > ORA-00904 invalid column name
> >
> > Cause: The column name entered is either missing or invalid.
> >
> > Action: Enter a valid column name. A valid column name must begin with a
> > letter, be less than or equal to 30 characters, and consist of only
> > alphanumeric characters and the special characters $, _, and #. If it
> > contains other characters, it must be enclosed in double quotation
marks.
> It
> > may not be a reserved word.
> >
> > Question:
> > Is this some know problem? If so, please share the solution, or the
> > direction in which we need to look for the solution.
> >
> > Gratitude:
> > Thank you for any and all help.
> >
> >
> >
> >
>
>
Received on Mon Mar 10 2003 - 13:20:52 CET