0 Replies Latest reply: Nov 12, 2012 7:25 PM by TrojanSpirit RSS

    Character Set Mismatcvh Error

    TrojanSpirit
      Hello,

      I have following query with me that I am trying to run:

      SELECT  Script from (

      *SELECT 9 as ColOrder, ' INSERT INTO  PROJ  VALUES(' || ID || ',''' || Name || ''', ''' || Version || ''', ''ABCD'', sysdate , ''ABCD'', sysdate);'  as Script FROM  PROJ  where Name like '%[Param.1]%'*

      union

      *SELECT 11 as ColOrder,' INSERT INTO  PROJMOD  VALUES(' || ID  || ', ' || ProjID  || ', ' ||  ModID  || ', ' ||  ObjID || ', ''ABCD'',  sysdate, ''ABCD'', sysdate);'  as Script FROM  PROJMOD  where ProjID in ( select ID from PROJ where Name like '%[Param.1]%')*

      *) x*

      Order by ColOrder

      But it gives me ORA-12704: character set mismatch error.

      When I run both the select statement individually, it gives me proper output but when I am doing union of both select, it gives tme character set mismatch error.

      What can be wrong here?