Hi,
I need help as I want to read 10000 Char text in SAS and insert into Oracle table -
Can someone help me with the code?
Thanks!
Have your checked your DBMAX_TEXT setting?
Either on the LIBNAME statement or as a dataset option.
I can read the 10000 character variable from sas but unable to put into the oracle table.
Have your checked your DBMAX_TEXT setting?
Either on the LIBNAME statement or as a dataset option.
Do I understand it correctly that the varcghar2 column has a defined max length of 4000?
And that can't be extended?
"Variable-length character string having maximum length size
bytes or characters. You must specify size
for VARCHAR2
. Minimum size
is 1 byte or 1 character. Maximum size is:
32767 bytes or characters if MAX_STRING_SIZE
=
EXTENDED
4000 bytes or characters if MAX_STRING_SIZE
=
STANDARD"
So question is are you willing to truncate the variable to 4000 chars? If so, there should not be a problem inserting it into Oracle (substr).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.