ORA-29275 - partial multibyte character (Analytics Pro)

terry711 — Mon, 17 Sep 2012 09:23:14 GMT

Hi,

I'm new to SAS Analytics Pro.

Got the following error when reading data from Oracle database.

It seems like the character set between SAS and Oracle DB does not match.

2    Data test;
3    set orapmkt.v_dw_hk_misc_clickthrough;
4    run;

ERROR: Error fetching from cursor. ORACLE error is ORA-29275: partial multibyte character and no result.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 500 observations read from the data set ORAPMKT.V_DW_HK_MISC_CLICKTHROUGH.
WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 500
observations and 15 variables.

I have searched related documents on web and cannot find some sample script on how to set the character set to UTF-8 in the SAS section when retrieving the data.

Can someone help to answer where to put ENCODING=UTF-8?

Thanks a lot.

Re: ORA-29275 - partial multibyte character (Analytics Pro)

Patrick — Mon, 17 Sep 2012 23:55:23 GMT

You will find the doc for this area of questions under NLS (national language support).

Not sure if below link is the answer:

http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n08gwe43ne71imn1oz7se05kthxi.htm

Try to get support from your SAS Admin at your site for this. It's not really something a SAS "business" user should have to solve on it's own.

topic ORA-29275 - partial multibyte character (Analytics Pro) in SAS Programming

ORA-29275 - partial multibyte character (Analytics Pro)

Re: ORA-29275 - partial multibyte character (Analytics Pro)