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 FEBRUARY 18, 2021

Applies to:

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


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:

- 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

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.






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

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