forms passing where clause to reports and 904 error

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Fri, 07 Mar 2003 14:04:26 GMT
Message-ID: <KF1aa.5892$J51.1230306_at_news1.news.adelphia.net>

Oracle:
[Quoted] 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 [Quoted] the two as C/S works just fine and the report is produced. But running the [Quoted] 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 [Quoted] may not be a reserved word.

Question:
[Quoted] 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 Fri Mar 07 2003 - 15:04:26 CET