[FORMS] add_parameter problem - parenthesis

[qba]

Hello,
I've got the problem with ADD_PARAMETER function. I have to pass the
varchar2 parameter to report and problem appeares when the string contains
the parenthesis ("). Do you know what to do to pass parenthesis to the
report wih add_parameter? Of course I can replace this sign with for example
', but - if its possible - I'd rather not to change value of a string.

Thans for any advice, qba.

[Anna C. Dent]

qba wrote: Hello, I've got the problem with ADD_PARAMETER function. I have to pass the varchar2 parameter to report and problem appeares when the string contains the parenthesis ("). Do you know what to do to pass parenthesis to the report wih add_parameter? Of course I can replace this sign with for example ', but - if its possible - I'd rather not to change value of a string.

I use CHR() function to concatenate "special" characters;
such as parenthesis or signle quote marks, into VARCHAR2 variables.

[qba]

> I use CHR() function to concatenate "special" characters; such as parenthesis or signle quote marks, into VARCHAR2 variables.

I have got the situation: there is an element (param_value) on the canvas
which is edited by users, I take the value this elmt and with add_parameter
add to the list of parameters, then I run reports.
----
add_parameter(list_id, param_name, TEXT_PARAMETER, :block_name.param_value);
....
run_product(reports,.......);
----

Replacing sign " with chr(ascii('"')) in the string :block_name.param_value
changes nothing - list still contains bad sign.