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).
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: