Parser Error wirh # sign

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.