4 Replies Latest reply on Nov 13, 2018 9:13 AM by 3418577

    SPARQL SERVICE SEM_MATCH ORA-06502: PL/SQL: numerisk fejl eller værdifejl: character string buffer too small

    3418577

      Hi

       

      Playing around with SPARQL sem_match with SERVICE call i suddenly get an ora-6502 (QUERY works with LIMIT 97 brakes with limit 98 so some kind of hard limit somewhere around 20000Bytes (output size or the like) ?!?!?)

       

      select bbr,fredningstype,ctype,year,fredningssag

      from table(sem_match(

      'PREFIX GRUNDDATA: <http://data.gov.dk/grunddata/>

      SELECT *

      WHERE {

         SERVICE <http://10.48.193.65:8080/fredetbygning/oracle> {

            select * WHERE {?f GRUNDDATA:hasBBR ?bbr .

                            ?f GRUNDDATA:preservationType ?fredningstype .

                            ?f GRUNDDATA:constructionType ?ctype .

                            ?f GRUNDDATA:constructionYear ?year .

                            ?f GRUNDDATA:preservationCase ?fredningssag} limit 98

         }

      }'

      ,sem_models('dummy')

      ,null,null,null,null

      ,null));

       

      LIMIT 97 works:

      B11D4978-FB30-40B7-9C10-B5A9D8701ACA Fredet Redningsstation 1928 http://www.kulturarv.dk/fbb/case/14392300

      C671EB0B-5679-45FD-A4A0-68CBD62EA4DD Fredet Vandm\u00C3\u00B8lleanl\u00C3\u00A6g 1880 http://www.kulturarv.dk/fbb/case/12172807

      918ADB7C-F904-4841-A69A-AC7788E01961 Fredet Ukendt 1763 http://www.kulturarv.dk/fbb/case/8472062

      7ACDA930-A774-43CD-AA03-D09855063DF1 Fredet Beboelse mm. 1805 http://www.kulturarv.dk/fbb/case/14392212

       

      limit 98 gives :

       

      ORA-20000: Error in SPARQL SERVICE:

      ORA-20000: Error reading

      ORA-06502: PL/SQL: numerisk fejl eller værdifejl: character string buffer too small

      ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 1126

      ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 1136

      ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 639

      ORA-06512: ved "MDSYS.SPARQL_SERVICE_IMPL_T", linje 1054

       

       

      Which buffer is "broken" ? Any idea what to try ?