https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787505#M251641 Great! I didn't find this option, thanks a lot Patrick Tue, 28 Dec 2021 07:36:34 GMT monicluder 2021-12-28T07:36:34Z https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787460#M251618 <P>Hello!</P><P>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&nbsp; a text (NVARCHAR), is there a tricks to do it? I use proc sql or data step.</P><P>Thanks a lot!</P> Mon, 27 Dec 2021 15:34:25 GMT https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787460#M251618 monicluder 2021-12-27T15:34:25Z https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787492#M251634 <P>Looks like you have run into the SAS option <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n1aqglg4ftdj04n1eyvh2l3367ql.htm" target="_blank" rel="noopener">DBMAX_TEXT</A> 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.</P> <P>&nbsp;</P> <P>How are you connecting to Oracle? The DBMAX_TEXT option can be used in database CONNECTION and LIBNAME statements.</P> Mon, 27 Dec 2021 23:25:10 GMT https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787492#M251634 SASKiwi 2021-12-27T23:25:10Z https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787496#M251637 <P>According to the Oracle documentation NVARCHAR won't exceed 32767 bytes and though can fit into a single SAS character variable.&nbsp;</P> <P>Follow&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13976">@SASKiwi</a>'s recommendation and set&nbsp;<SPAN>&nbsp;</SPAN><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n1aqglg4ftdj04n1eyvh2l3367ql.htm" target="_blank" rel="noopener nofollow noreferrer">DBMAX_TEXT</A>&nbsp;to 32767. That should resolve the issue.</P> Tue, 28 Dec 2021 01:58:21 GMT https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787496#M251637 Patrick 2021-12-28T01:58:21Z https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787505#M251641 Great! I didn't find this option, thanks a lot Patrick Tue, 28 Dec 2021 07:36:34 GMT https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787505#M251641 monicluder 2021-12-28T07:36:34Z https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787506#M251642 Great! I didn't find this option, thanks a lot SASkiwi Tue, 28 Dec 2021 07:37:03 GMT https://communities.sas.com/t5/SAS-Programming/how-is-it-possible-to-import-a-LOB-from-a-data-base/m-p/787506#M251642 monicluder 2021-12-28T07:37:03Z