Re: forms passing where clause to reports and 904 error

[Quoted] 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 Sat Mar 08 2003 - 04:23:04 CET