BookmarkSubscribeRSS Feed
Pdogra
Calcite | Level 5
I am hoping that you help me this issue:

I a trying to create a table on Oracle server (Oracle 10 G) using proc sql:
All I am doing is - Bringing data from Oracle Server A and passing it to Oracle server B (please see the code):

Proc sql;

create table crmrs133.sales as

select subscriber_seq, address_seq,campaign_number, selling_group_code
from m_owner.Sales_work_order
where datepart(report_date) between '01mar2009'd AND '31mar2009'd ;
QUIT;

CRMRS133 : Oracle server where table sales is being created hosted on Unix box A.
M_owner is another Oracle server on Unix Box B.

Error I get is :

NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: ORACLE execute error: ORA-01461: can bind a LONG value only for insert into a LONG column.
WARNING: File deletion failed for CRMRS133.SALES.DATA.

How can i resolve this issue.
This code was run on PC SAS (not Unix SAS).
1 REPLY 1
LinusH
Tourmaline | Level 20
After checking SAS notes, I found these two:
http://support.sas.com/kb/10/019.html
http://support.sas.com/kb/11/678.html

They bot implies that you have wrong Oracle module linked from SAS. Check your versions numbers. If they seem to the correct ones, contact SAS tech support. Otherwise - upgrade...

/Linus
Data never sleeps

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1070 views
  • 0 likes
  • 2 in conversation