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).
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.