Help! WebDB char parm?

This one must be very simple but it just has me stumped.

I have created an sql-based WebDB report and am trying to pass a char field as a run-time parm. I've coded the sql such:

select x,y,z
from table_a
where x = :x_parm

Field x is defined in the table as char(40).

When I run the report and key in a valid value for x, no rows are returned. It appears there are no single quotes placed around the :x_parm value when it is parsed and executed. I can see that the raw value is passed and used in the sql because I have turned on the 'display sql' feature in WebDB, but no quotes.

I have tried everything I can think of in the sql statement to force the single quotes around the bind variable :x_parm, but no luck so far.

I can execute this query in TOAD, using the :x_parm bind variable, and it returns the data.

What am I doing wrong?     Received on Fri Aug 04 2000 - 00:00:00 CEST