Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic Where clause in Oracle reports

Dynamic Where clause in Oracle reports

From: DJ <dlj_at_pbell.com>
Date: Wed, 23 Sep 1998 15:54:52 -0800
Message-ID: <36098A4C.48E5@pbell.com>


Newbie qestion on Lexical Where Clause? Using VMS/VAX os, reports 2.5

Trying to replace my where clause using a lexical, it returns an invalid column error. Has anybody experenced this problem. The columns are correct because they were cut/paste into a string that was assigned to the parameter that is being used as a lexical. In addition this parameter is assigned in the AfterParmForm Tigger. Note: in SQL this string did return rows and the report was running before we tried to use the lexical. Can the & symbol cause problems on the VAX because it is a special character? Any help will be appreciated. PLease post to news group.

Thanks

dj Received on Wed Sep 23 1998 - 18:54:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US