DATA Step, Macro, Functions and more

Uploading Data on Oracle Server

Reply
Occasional Contributor
Posts: 16

Uploading Data on Oracle Server

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).
Super User
Posts: 5,437

Re: Uploading Data on Oracle Server

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
Ask a Question
Discussion stats
  • 1 reply
  • 165 views
  • 0 likes
  • 2 in conversation