Very Computer

by **Lis** » Thu, 20 Jun 2002 04:55:33

I am trying to reading data from an Oracle table that has field define as a
Oracle datatype. The SAS procedure I've tried is proc sql with the
following code:

proc sql;
connect to oracle (user="profile_user" orapw=XXXXXXXXX p
path="SMDWP");
create table work.collg as
select * from connection to oracle (select educational_experiences
from agc_sm_colleague2);

I am unable to do this successfully and get the following errors:

ERROR: Oracle DESCRIBE Error: ORA-03115: unsupported network datatype or
representation

Any suggestions,
Thanks.
-- Lisa

by **Shoemaker, Ja** » Thu, 20 Jun 2002 05:14:33

Lisa,

Is the column, educational_experiences, a CLOB data type? If so, you may be
hosed. - Jack

-----Original Message-----
From: Lisa

Sent: 6/18/02 3:55 PM
Subject: proc sql, Oracle and Clob datatypes

I am trying to reading data from an Oracle table that has field define
as a
Oracle datatype. The SAS procedure I've tried is proc sql with the
following code:

proc sql;
connect to oracle (user="profile_user" orapw=XXXXXXXXX p
path="SMDWP");
create table work.collg as
select * from connection to oracle (select
educational_experiences
from agc_sm_colleague2);

I am unable to do this successfully and get the following errors:

ERROR: Oracle DESCRIBE Error: ORA-03115: unsupported network datatype or
representation

Any suggestions,
Thanks.
-- Lisa

by **Shoemaker, Ja** » Thu, 20 Jun 2002 07:54:29

Of course. My mistake. Thanks for the correction Sig. - Jack

-----Original Message-----
From: Sigurd Hermansen

Sent: 6/18/02 6:45 PM
Subject: Re: proc sql, Oracle and Clob datatypes

I believe that the correct technical phrase in Oracle is '...you may be
clobbered'.
Sig

>Lisa,

>Is the column, educational_experiences, a CLOB data type? If so, you
may
be
>hosed. - Jack

>-----Original Message-----
>From: Lisa

>Sent: 6/18/02 3:55 PM
>Subject: proc sql, Oracle and Clob datatypes

>I am trying to reading data from an Oracle table that has field define
>as a
>Oracle datatype. The SAS procedure I've tried is proc sql with the
>following code:

>proc sql;
> connect to oracle (user="profile_user" orapw=XXXXXXXXX p
> path="SMDWP");
> create table work.collg as
> select * from connection to oracle (select
>educational_experiences
> from agc_sm_colleague2);

>I am unable to do this successfully and get the following errors:

>ERROR: Oracle DESCRIBE Error: ORA-03115: unsupported network datatype
or
>representation

>Any suggestions,
>Thanks.
>-- Lisa

by **Sigurd Hermans** » Thu, 20 Jun 2002 07:45:07