My Oracle Support Banner

APEX 180100 JSON Error And ORA-20987 Inserting A Default Bullet Point Into A Text Item (Doc ID 2617017.1)

Last updated on JULY 28, 2020

Applies to:

Oracle Application Express (APEX) - Version 18.1 to 19.1
Information in this document applies to any platform.

Symptoms

On : APEX 18.1 version

When attempting to insert the default bullet point:

from a Microsoft Word  document into an APEX text field the following error occurs:

ERROR
-----------------------
- ora_sqlerrm: ORA-20987: Error at line 1, col 54: Unexpected character "\"
- error_backtrace: ORA-06512: at "APEX_180100.WWV_FLOW_JSON", line 1108
ORA-06512: at "APEX_180100.WWV_FLOW_JSON", line 1194
ORA-06512: at "APEX_180100.WWV_FLOW_JSON", line 1218
ORA-06512: at "APEX_180100.WWV_FLOW", line 5346


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Create a Form with a single Text Field.
2.  Enter any text and summit and confirm it works OK.
3.  Cut and paste text from word that include bullet point with default symbol, see the error above.
4.  Change in word the default bullet point symbol to some other character then cut and paste in APEX form and it works fine.


 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.