Uploading Data on Oracle Server

Pdogra — Wed, 01 Apr 2009 14:20:53 GMT

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).

Re: Uploading Data on Oracle Server

LinusH — Thu, 02 Apr 2009 13:17:15 GMT

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

topic Uploading Data on Oracle Server in SAS Programming

Uploading Data on Oracle Server

Re: Uploading Data on Oracle Server