Home » SQL & PL/SQL » SQL & PL/SQL » ORA-29275 partial multibyte character
ORA-29275 partial multibyte character [message #265556] Thu, 06 September 2007 11:31 Go to next message
rpoduval
Messages: 1
Registered: September 2007
Junior Member
We have recently migrated our oracle databse from 9i to 10g while testing the application i am getting the following error for one of the packages :

ORA-29275: partial multibyte character

It happens on this query

INSERT INTO WORK_HIER_mdl(
MODEL_ID,
PRODUCT_ID,
MODEL_CODE,
ODM_CODE,
MODEL_DESC
)
SELECT /*+append*/
MODEL_ID,
PRODUCT_ID,
MODEL_CODE,
ODM_CODE,
MODEL_DESC
FROM SHLD_HIER_MDL;

description of both tables is same

MODEL_ID 1 N NUMBER (15)
PRODUCT_ID 2 Y NUMBER (15)
MODEL_CODE 3 Y VARCHAR2(54)
ODM_CODE 4 Y VARCHAR2 (9)
MODEL_DESC 5 Y VARCHAR2 (20)

SHLD_HIER_MDL is accessed through a DB link - DBLINK_SHLDL_SHLDW

Can you suggest if you see anything amiss here .
Re: ORA-29275 partial multibyte character [message #265560 is a reply to message #265556] Thu, 06 September 2007 11:35 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
29275, 00000, "partial multibyte character"
// *Cause:  The requested read operation could not complete because a partial
//          multibyte character was found at the end of the input.
// *Action: Ensure that the complete multibyte character is sent from the
//          remote server and retry the operation. Or read the partial
//          multibyte character as RAW.
Previous Topic: ORA-00917 error
Next Topic: Procedure Parameters
Goto Forum:
  


Current Time: Thu Dec 08 22:22:25 CST 2016

Total time taken to generate the page: 0.10639 seconds