1 Reply Latest reply on Jun 29, 2009 2:27 PM by Sdas-Oracle

    another Trouble... SQL Error: ORA-06502: PL/SQL: numeric or value error

    673499
      Hi, i got this problem :

      SQL Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
      ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 176
      ORA-06512: at line 1


      , The problem happened when i did a long query for example :

      SELECT suhu
      FROM TABLE(SDO_RDF_MATCH(
      '
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x rdf:type :Tempat)
      (?x :punya_suhu ?suhu)',
      SDO_RDF_Models('pariwisata'),
      SDO_RDF_RULEBASES('RDFS','pariwisata_rb'),
      SDO_RDF_Aliases(SDO_RDF_Alias('','http://www.owl-ontologies.com/Ontology1227225596.owl#')),
      null))

      ...
      that query above is just an example, when you did a long long long query that problem will come to you.. :(
      Anyone who knows this solution, pliz help me,,,



      *sorry for my poor English ;;)