3 Replies Latest reply on May 30, 2008 1:59 PM by alwu-Oracle

    SparQL Error

    609674
      Hi,
      I got a problem just now. I ran the following statement and got some errors.
      I found another thread Re: SEM_MATCH filter error And I think the cause is same. So I want to know when will Oracle public an upcoming patch that can solve this problem. Thanks

      Steven

      ORA-06502: PL/SQL: : character string buffer too small
      ORA-06512: "MDSYS.RDF_MATCH_IMPL_T", line 176
      ORA-06512: line 1

      select student from TABLE
      (SEM_MATCH( '(?Student rdf:type :Student)(?Student :Name ?name)
      (?Student :Birthday ?birth)(?Student :Description ?desc)
      (?Student :Class ?class)(?Student :Old ?old)
      (?Student :Department ?dept)(?Student :University ?univ)
      (?Student :Teacher ?teacher)
      (?Student :Address ?addr)(?Student :Telphone ?phone)
      (?Student :Sex ?sex)
      (?Student :Height ?height)
      ',
      SEM_Models('mrs_metadata'),null,
      SEM_Aliases(SEM_Alias('rdf','http://www.w3.org/1999/02/22-rdf-syntax-ns#'),
      SEM_Alias('', 'http://www.lscdd.lilly.com.sg/lscdd#')),
      null))
      where name = 'Jone'
      AND birth = '2008-05-26'
      AND desc = 'aaabbb'
      AND class = 'class one'
      AND old = '20'
      AND dept = 'dept one'
      AND univ = 'University one'
      AND teacher = 'Marry'
      AND addr = 'Street 1'
      AND phone = '123123133'
      AND sex = 'male'
      AND height = '180'