Oracle Apex: Escape Special Characters When Passing Parameters to Other Page

In Oracle Apex, if you will try to set the target page items from the calling page items having the special characters such as Comma (,), Hash (#) or Ampersand (&), etc. Then you may experience the error "Uncaught Error: Syntax error, unrecognized expression" when you will click the link to open the target page and the target page will show nothing due to error. In this tutorial, I will show you how you can escape special characters when passing parameters to other pages.

Escape Special Characters in Oracle Apex Example

I have the customer data and in the street address field there are many kinds of special characters and I need to pass this field as a parameter to the other page. The following is the screenshot of the data:

Data having special characters.

Now to pass this field as a parameter to other pages means by setting the target page value to this field I am using the backslashes (\) to escape the special characters of this field to prevent the "Uncaught Error: Syntax error, unrecognized expression" error. As shown in the below image:

Oracle Apex - Target Link Builder

Now because of the backslashes around the Value field (\#CUST_STREET_ADDRESS1#\), you will not experience the error.

This is the field from an Interactive Report, if you are passing the value from an Interactive Grid or a normal Page Item then use the following syntax:

\&CUST_STREET_ADDRESS1.\

\&P19_CUST_STREET_ADDRESS1.\

To escape HTML online, check this tool.

Related tutorials:

Reference:

Vinish Kapoor
Vinish Kapoor

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.