Cannot use a double quote as a string delimiter in a Oracle Report 10g.
In 6i Report, it was ok to use “ (double quote) as a character delimiter
But it is Not ok in 10g Report.
Currently, we use double quotes to overcome parameter passing problems in 6i
And will have to search every report to locate the potential problems (it’s data dependent).
The fastest and most efficient way to fix this problem would be allowing the both single and double quote as delimiters.
Is there any setting specify what characters can be used as a string delimiters some where?
Thanks,
e.g.
and cm.cli_id = '761256'