how is it possible to import a LOB from a data base

[monicluder]

Hello!

I know there is the length limit for char variable (1024 positions); but if I have to import a field of a data base Oracle which contains  a text (NVARCHAR), is there a tricks to do it? I use proc sql or data step.

Thanks a lot!

[SASKiwi]

Looks like you have run into the SAS option DBMAX_TEXT default setting of 1024. You can increase this to 32767 but no more than that as that is the size limit of SAS character variables.

How are you connecting to Oracle? The DBMAX_TEXT option can be used in database CONNECTION and LIBNAME statements.

[monicluder]

Great! I didn't find this option, thanks a lot SASkiwi

[Patrick · Accepted solution]

According to the Oracle documentation NVARCHAR won't exceed 32767 bytes and though can fit into a single SAS character variable. 

Follow @SASKiwi's recommendation and set  DBMAX_TEXT to 32767. That should resolve the issue.

[monicluder]

Great! I didn't find this option, thanks a lot Patrick