Re: Oracle Reports 2.5 (lexical references) question

Venkata Repaka <vrepaka_at_sctcorp.com> writes:  

>One of the lexical references is used to pass the where clause
>to the report. When I pass a parameter to reports with an embedded
>blank space (e.g. CCW 1) in the value for the database column, reports
>is aborting without any error message. Has anyone encountered such a
>problem?
 

This has something to do with how Forms passes parameters to Reports, via a DOS command line (?).  

On the Forms side, we use the PL/SQL function TRANSLATE to change all blanks to something "safe", like "|". In the Before-Report trigger in Reports, we then use TRANSLATE again to restore the "|" characters to blanks.  

Crude, but effective.  

• Rick --

(Rick Rutt is a system architect living and working in Midland, Michigan.) Received on Sun Sep 01 1996 - 00:00:00 CEST