Oracle Reports (MOSC)

MOSC Banner

Need plus sign (+) to show up in reports.

edited Nov 1, 2010 8:04AM in Oracle Reports (MOSC) 3 commentsAnswered
I'm trying to get the plus sign to show up in reports. I am calling the reports from a form. I'm using web.show_document to call the reports. In order for this to work, I have to use a replace statement in forms to send the parameters to the reports. Then I have to use the replace statement in the reports so that I can get the special characters back in the fields.
Here's an example:

From forms:
l_description := replace(:description,chr(35),'poundsign'); l_repstring := ...||'&p_desc='||l_description||...; web.show_document(l_repstring);
Where p_desc is a user parameter on the report.

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