1 Reply Latest reply on Jan 13, 2014 10:04 PM by SriniVEERAVALLI

    ANSI SQL Error in TOAD

    1056326

      Hi,

       

      when I try and run the following in TOAD I get an invalid character error (90011), does TOAD not support ANSI the code is from a mapping that runs on the same database and i've just stripped it out to see what it returns...

       

      SELECT W_GL_BALANCE_FS.LEDGER_ID,

      W_GL_ACCOUNT_D.ROW_WID GL_ACCOUNT_WID,

      W_GL_ACCOUNT_D.PROFIT_CENTER_NUM,

      W_GL_ACCOUNT_D.PROFIT_CENTER_ATTRIB,

      W_GL_BALANCE_FS.PROFIT_CENTER_ID,

      W_GL_BALANCE_FS.COMPANY_ORG_ID,

      W_INT_ORG_D.ROW_WID BUSN_AREA_ORG_WID,

      W_GL_BALANCE_FS.GL_ACCOUNT_ID,

      W_GL_BALANCE_FS.BALANCE_DATE,

      W_GL_BALANCE_FS.DB_CR_IND,

      W_GL_BALANCE_FS.BALANCE_TYPE_FLAG,

      W_GL_BALANCE_FS.TRANSLATED_FLAG,

      W_GL_BALANCE_FS.LOC_CURR_CODE,

      W_GL_BALANCE_FS.ACCT_CURR_CODE,

      W_GL_BALANCE_FS.SUMMARY_ACCOUNT_FLAG,

      W_GL_BALANCE_FS.INTEGRATION_ID,

      W_GL_BALANCE_FS.DATASOURCE_NUM_ID,

      W_GL_BALANCE_FS.TENANT_ID,

      W_GL_BALANCE_FS.X_CUSTOM,

      W_GL_BALANCE_FS.BALANCE_ACCT_AMT, W_GL_BALANCE_FS.ACTIVITY_ACCT_AMT, W_GL_BALANCE_FS.BALANCE_LOC_AMT, W_GL_BALANCE_FS.ACTIVITY_LOC_AMT, W_GL_BALANCE_FS.LAST_UPDATE_DATE,

      W_GL_BALANCE_FS.AUX1_CHANGED_ON_DT,

      W_GL_BALANCE_FS.AUX2_CHANGED_ON_DT,

      W_GL_BALANCE_FS.AUX3_CHANGED_ON_DT,

      W_GL_BALANCE_FS.AUX4_CHANGED_ON_DT,

      W_GL_BALANCE_FS.ADJUSTMENT_FLAG,

      W_MCAL_CONTEXT_G.MCAL_CAL_WID,

      W_GL_BALANCE_FS.BALANCE_ID

      FROM

      W_GL_BALANCE_FS,

      W_GL_ACCOUNT_D,

      W_MCAL_CONTEXT_G,

      W_INT_ORG_D

      WHERE

      W_GL_BALANCE_FS

      LEFT OUTER JOIN W_INT_ORG_D ON

      W_GL_BALANCE_FS.BUSN_AREA_ORG_ID = W_INT_ORG_D.INTEGRATION_ID AND

      W_GL_BALANCE_FS.DATASOURCE_NUM_ID = W_INT_ORG_D.DATASOURCE_NUM_ID

      LEFT OUTER JOIN W_GL_ACCOUNT_D ON

      W_GL_BALANCE_FS.DATASOURCE_NUM_ID = W_GL_ACCOUNT_D.DATASOURCE_NUM_ID AND

      W_GL_BALANCE_FS.GL_ACCOUNT_ID = W_GL_ACCOUNT_D.INTEGRATION_ID AND

      W_GL_BALANCE_FS.BALANCE_DATE >= W_GL_ACCOUNT_D.EFFECTIVE_FROM_DT AND

      W_GL_BALANCE_FS.BALANCE_DATE < W_GL_ACCOUNT_D.EFFECTIVE_TO_DT

      LEFT OUTER JOIN W_MCAL_CONTEXT_G ON

      W_GL_BALANCE_FS.LEDGER_ID = W_MCAL_CONTEXT_G.LEDGER_ID AND

      W_GL_BALANCE_FS.DATASOURCE_NUM_ID = W_MCAL_CONTEXT_G.DATASOURCE_NUM_ID AND

      W_MCAL_CONTEXT_G."CLASS" = 'GL'

       

      Any ideas?

       

      Thanks,