Oracle Reports (MOSC)

MOSC Banner

Cannot use a double quote as a string delimiter in a Oracle Report 10g.

edited Jan 10, 2011 7:11PM in Oracle Reports (MOSC) 1 commentAnswered
Found a problem with 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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center