This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Dec 25, 2012 12:35 AM by ranit B RSS

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

DavidPaul Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points