Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    2

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

    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

    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. #2
    Join Date
    Jul 2009
    Posts
    2
    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

    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.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If you say so.
    We have no way to verify what you claim.

    Code:
    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;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •