topic Re: How do I write to an oracle table with name >32 Char in SAS Programming

How do I write to an oracle table with name >32 Char

stuart_snap — Thu, 03 Nov 2016 21:03:19 GMT

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!

Re: How do I write to an oracle table with name >32 Char

SASKiwi — Fri, 04 Nov 2016 00:23:33 GMT

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;

Re: How do I write to an oracle table with name >32 Char

LinusH — Fri, 04 Nov 2016 07:35:16 GMT

Or create a view with a name with 32 or less chars.