Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using APEX_JSON in Validation Process and returning error text will end up in "Error: SyntaxError: U

puchtecMay 3 2018 — edited May 4 2018

I am wondering that I will get "Error: SyntaxError: Unexpected end of JSON input" instead of the simple text message my validation process is creating. I investigated a little and found, that because I am using APEX_JSON (as workaround till database gets upgraded to 12.2) for calls to a 3rd party system, the APEX error handling returns with this message instead the message I would expect. The debug shows "Emit error as JSON", which I guess causes the "Unexpected end of JSON input".

If I do not invoke APEX_JSON, the simple text error message is shown up. Only if I leverage APEX_JSON (for some internal stuff within the PL/SQL call) I am facing the error message "Error: SyntaxError: Unexpected end of JSON input".

Anybody aware of this or could advice how to proceed?

Thx,

Frank

Environment:

I am using APEX 5.1.4 running on Oracle Database 12.1. Thus, I have to use APEX_JSON instead of native JSON (will become available in 12.2 for PL/SQL).

This post has been answered by Christian Neumueller-Oracle on May 3 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2018
Added on May 3 2018
19 comments
2,603 views