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.\

Related tutorials:

Reference:

Leave a Reply