| ORA-29275 partial multibyte character [message #265556] |
Thu, 06 September 2007 11:31  |
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  |
 |
BlackSwan
Messages: 26766
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
