Hi.
Is it possible to write to an Oracle table thats name is longer than 32 Char? I am able to read it using SQL Passthrough as suggested in several other threads, but when I try to insert some rows, i get...
"ERROR 65-58: Name 'WP_MARKETINGPROMOTIONSELIGIBILITY_BKUP' is too long for a SAS name in this context."
I am using the code below. Am I missing something, or is writing not possible?
data test;
input cardcode $ promoid took $ segmentatdrop $ presented $ presenteddate presentedby;
cards;
S123456 3000 N Fringe Y . 999
S123457 3000 N Fringe N . 999
S123458 3000 N Fringe N . 999
run;
proc sql;
connect to odbc as myconn (datasrc=Prod user=sas password="edited" readbuff=3000);
insert into WP_MarketingPromotionsEligibility_bkup (cardcode, promoid, took, segmentatdrop, presented, presenteddate, presentedby)
select * from test;
disconnect from myconn;
quit;
Thanks!
Your insert into is not in a PASSTHRU step:
proc sql;
connect to odbc as myconn (datasrc=Prod user=sas password="edited" readbuff=3000);
execute (
insert into WP_MarketingPromotionsEligibility_bkup (cardcode, promoid, took, segmentatdrop, presented, presenteddate, presentedby)) by myconn;
disconnect from myconn;
quit;
Your insert into is not in a PASSTHRU step:
proc sql;
connect to odbc as myconn (datasrc=Prod user=sas password="edited" readbuff=3000);
execute (
insert into WP_MarketingPromotionsEligibility_bkup (cardcode, promoid, took, segmentatdrop, presented, presenteddate, presentedby)) by myconn;
disconnect from myconn;
quit;
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.