2 Replies Latest reply on Nov 29, 2007 7:00 PM by 24743

    Views in 11g

    24743
      Hii

      When creating a view in 11g like:

      CREATE VIEW test_v AS
      SELECT s, p, o
      FROM TABLE (sem_match ('(?s ?p ?o)', sem_models ('test'), NULL, NULL, NULL));

      I get: ORA-00600: internal error code, arguments: [17046], [0x1B9DDA24], [0x1B1918C0], [1], [], [], [], []

      This was OK in 10g - and also in 11g as a materialized view.

      Best regards - Christian
        • 1. Re: Views in 11g
          Mannamal-Oracle
          Hi Christian,

          This issue will be fixed in an upcoming patch. A workaround can be used as follows:

          create view males as
          SELECT x
          FROM TABLE(SEM_MATCH(
          '(?x ?y <http://www.example.org/family/Male>)',
          SDO_RDF_Models('family'),
          null,
          SDO_RDF_Aliases(SDO_RDF_Alias('','http://www.example.org/family/')),
          null,
          null,
          'REWRITE=F'));

          The 'REWRITE=F' is an undocumented way to pick a certain code path. Please note that it is the last argument to SEM_MATCH, hence all the previous arguments have to have a value or have nulls. In the example above I used nulls.

          Again this will be fixed in an upcoming patch.

          Melli
          • 2. Re: Views in 11g
            24743
            Hi Melli

            Works!

            Thanks - Christian