I'll get following error:
ORA-20100: JSON Scanner exception @ line: 1 column: 367 - Unexpected char: #
Here's my testcase:
obj := json();
obj.put('Column', json_list('[' || 'OBJ#' || ']'));
I'll get the same error with the "$" sign. Is there any solution for this problem?
Looks we are all facing similar problems, whether it be a symbol or special character. Matt suspect the multi byte character set. I'm facing the same issue when extracting special characters such as though found in the German and French languages.
Hopefully Jonas can offer a work around.
Log in to post a comment.