Menu ▾ ▴

Parser Error wirh # sign

Open Discussion
DB-Support
2013-01-07
2013-05-28

  • DB-Support

    DB-Support - 2013-01-07

    Hi!

    I'll get following error:

    ORA-20100: JSON Scanner exception @ line: 1 column: 367 - Unexpected char: #

    Here's my testcase: 

    DECLARE 
  obj  json; 
BEGIN
   obj := json();
   obj.put('Table', 'TEST');
   obj.put('Column', json_list('[' || 'OBJ#' || ']'));
END;

    I'll get the same error with the "$" sign. Is there any solution for this problem?

    Best regards,
    Dennis

     

  • Ja Steam

    Ja Steam - 2013-01-07

    Hello Denis,

    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.

    http://sourceforge.net/projects/pljson/forums/forum/935365/topic/5595609

    Hopefully Jonas can offer a work around.

    Jan S.

     

Log in to post a comment.