0

I am trying to execute the below script

CREATE VIEW JOES.WEBSKULOOKUPVIEW ( 
    STYLEID , 
    STYLENAME , 
    DISPLAYSTYLENUMBER , 
    B2BSTYLE , 
    WEBPRODDESCR , 
    WEBSTYLENAME , 
    WEBSKUNUMBER , 
    SUPPLIERNAME , 
    SKUID , 
    SKUNUMBER , 
    SKUACTIVESTATUS , 
    B2BSKU , 
    SKUSIZE , 
    SKUCOLOUR , 
    WPSTYLEID ) 
    AS 
    SELECT DISTINCT ESTYLE.STYLEID, ESTYLE.STYLENAME, ESTYLE.DISPLAYSTYLENBR, ESTYLE.B2BSTYLE, WPROD.H1SJXT, WPSTYLE.H2AMNA, 
                    WPSKU.H3DINB, SUPP.SUPPLIERNAME, ESKU.SKUID, ESKU.SKUNUMBER, ESKU.SKUACTIVESTATUS, ESKU.B2BSKU,  
                    (COALESCE(TRIM(FIRSTSIZE.SHORTSCALEVALUE) , '') || COALESCE(TRIM(', ' || SECSIZE.SHORTSCALEVALUE), '')) AS "SIZE",  
                    STYLEACTUALCOLOUR.SPECIFICCOLOURNAME , STYLE.STYLEID  
                    FROM ENTERPRISE.STYLE ESTYLE, ENTERPRISE.SUPPLIER SUPP, MWWDATA.DGH1CPP WPROD,  
                     MWWDATA.DGH2CPP WPSTYLE, MWWDATA.DGH3CPP WPSKU, ENTERPRISE.STOCKKEEPINGUNIT ESKU, ENTERPRISE.STYLEACTUALCOLOUR STYLEACTUALCOLOUR,  
                     ENTERPRISE.STYLE STYLE, ENTERPRISE.STYLEACTSTATUS STYLEACTSTATUS, ENTERPRISE.STYLEACTSTATUS SKUACTSTATUS, ENTERPRISE.SKUSIZE SKUSIZE  
                    LEFT OUTER JOIN ENTERPRISE.SIZESCALEVALUE FIRSTSIZE ON FIRSTSIZESCALEID = FIRSTSIZE.SIZESCALEID AND FIRSTSIZESCALEOBJI = FIRSTSIZE.SIZESCALEOBJID  
                    LEFT OUTER JOIN ENTERPRISE.SIZESCALEVALUE SECSIZE ON SECSIZESCALEID = SECSIZE.SIZESCALEID AND SECSIZESCALEOBJID = SECSIZE.SIZESCALEOBJID          
                    WHERE   ESTYLE.DEFAULTSUPPLIERID = SUPP.SUPPLIERID AND  
                        SUPP.VENDORENTITYCODE = WPSTYLE.H2RWCO AND  
                        ESTYLE.STYLEUSERCODE = WPSTYLE.H2AICD AND  
                        WPSTYLE.H2SCNS = WPROD.H1SCNS AND  
                         WPROD.H1SCNS = WPSTYLE.H2SCNS AND  
                        WPSTYLE.H2SCNS = WPSKU.H3SCNS AND  
                        WPSTYLE.H2RWCO = WPSKU.H3RWCO AND  
                        WPSTYLE.H2AICD = WPSKU.H3AICD AND  
                        WPSKU.H3DINB = CAST (ESKU.SKUNUMBER AS DECIMAL) AND  
                        STYLE.STYLEID = ESKU.STYLEID AND  
                        ESKU.STYLEID = STYLEACTUALCOLOUR.STYLEID AND  
                        ESKU.ACTUALCOLOUROBJID = STYLEACTUALCOLOUR.ACTUALCOLOUROBJID AND  
                        STYLE.STYLEACTIVESTATUS = STYLEACTSTATUS.STYLEACTIVESTATUS AND  
                        ESKU.SKUACTIVESTATUS = SKUACTSTATUS.STYLEACTIVESTATUS AND  
                        ESKU.SKUID = SKUSIZE.SKUID AND SKUACTIVESTATUS NOT IN ('P', 'D') ;

And it throws the error as mentioned below.

(COALESCE(TRIM(FIRSTSIZE.SHORTSCALEVALUE) , '') || COALESCE(TRIM(', ' || SECSIZE.SHORTSCALEVALUE), '')) AS "SIZE",
                                                                                    *
ERROR at line 20:
ORA-12704: character set mismatch

But that is the syntax for coalesce and trim.

So what possible changes should I make to solve this issue.

sabarish jackson
  • 149
  • 3
  • 10

0 Answers0