1 2 Previous Next 26 Replies Latest reply: Dec 25, 2012 2:35 AM by ranit B RSS

    Dynamic SQL run with error 'ORA-29275: partial multibyte character'

    DavidPaul
      Hi All,

      In daily work, we use daynamic SQL to load data from another database through DB Link. However, even if I run the following simple statement in our DB, it will raise the error.

      CREATE TABLE TEST_TMP
      AS
      SELECT TRANSACTION_REASON
      FROM APPS.MTL_TRANSACTION@OAPPS.COM --it is using db link.
      WHERE LAST_UPDATE_DATE>=TO_DATE('18-12-2012 22:01:58', 'dd-mm-yyyy hh24:mi:ss');

      This statement had been workng correctly before OCT-2012 and there was no change with the source. Afterwards, there was just a change which upgraded the DB version from 10g to 11g on our side. I have browsed my technical articles, but I still cannot find the root cause. Is it due to the updgrading of the DB which practice stricter sanity check?

      I don't know.

      I'd appreciate of you can give me suggestion if you know such case.

      Thanks,
      David
        1 2 Previous Next