1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle 11g error ORA-00932: inconsistent datatypes: expected - got CLOB

Discussion in 'SQL PL/SQL' started by akarelia, Jul 15, 2009.

  1. akarelia

    akarelia Guest

    Hi all,
    I am getting strange behaviour from oracle 11g. I get the above mentioned error on 11g but the query works fine on 10g. Query being
    Code (SQL):
    SELECT   si.home, SUM (si.score) AS search_score
        FROM search_index si
       WHERE (si.home IN (
                 SELECT a.home
                   FROM assets a INNER JOIN assets_lnk l ON l.cell_no = a.home
                        INNER JOIN assets_lnk_tree t ON t.linking = l.linking
                  WHERE ((t.root LIKE 'there%') OR (t.root LIKE 'here%'))
                    AND a.TYPE IN ('folder'))
             )
         AND (contains (si.VALUE, '%folder%', 1) > 0)
    GROUP BY si.home;
    also if i take off one of the (t.root LIKE 'there%') OR (t.root LIKE 'here%') the query works fine.
    Thanks in advance.
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    hi

    actually it's very difficult to find an error from the select query. You should provide a few create table and insert statements.

    Anyways, what is the datatype of t.root? is it varchar2? try to_char(t.root) like 'there%'.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    The Error Description ..