BookmarkSubscribeRSS Feed
ykk
Obsidian | Level 7 ykk
Obsidian | Level 7

We are getting the below Error while running the PROC SQL code using the Library which was connected to the Oracle

ERROR: Error fetching from cursor. ORACLE error is ORA-29275: partial multibyte character.

Can you please suggest

4 REPLIES 4
SASKiwi
PROC Star

Please provide your SQL code as well.

ykk
Obsidian | Level 7 ykk
Obsidian | Level 7

Below is the PROC SQL Code

PROC SQL;

CREATE TABLE GRIDWORK.VSOE_DATA

AS

SELECT * FROM FVEPROD.VSOE_FVC_DEAL_LINE_DTLS_VW;

RUN;

FVEPROD is the Libname which points to Oracle Database.

SASKiwi
PROC Star

I googled your problem and it appears to be caused when the Oracle server language settings do not match SAS's. I would try to find out from your Oracle DBA what the NLS settings are and then compare them with SAS's.

https://community.oracle.com/message/10762725

Patrick
Opal | Level 21

As points out the issue is very likely caused by different encodings. There are a few libname options like DBSERVER_MAX_BYTES which eventually could allow you to retrieve data from Oracle in such a situation without getting an error (not sure, you have to try). SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Sixth Edition

....but even if this should work it won't resolve the issue of different encodings and if Oracle is multibyte but SAS is single byte then there are simply characters which can't get properly represented. If your actual data are only English letters and the like then things could still work for you - but you'll never have a guarantee.

The only actual solution is to run SAS and Oracle in an encoding which is compatible.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 6469 views
  • 0 likes
  • 3 in conversation