Date:         Tue, 6 Jun 2006 19:51:31 -0400
Reply-To:     "Michael F. Murphy" <Michael.F.Murphy@KP.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Michael F. Murphy" <Michael.F.Murphy@KP.ORG>
Subject:      Re: Oracle DB Support / OpenVMS support
Comments: To: paulhill20@COPPER.NET

We are using SAS 8.2 on the OpenVMS platform and Oracle9i Enterprise
Edition Release 9.0.1.4.0. We are not having any problem using the libname
statement to load SAS data sets into Oracle. Nor accessing Oracle tables
and view using SAS. Is this what you mean by "connect/pull/push data"?

Have you tried to use the older version of loading, PROC DBLOAD, instead of
the libname statement for loading SAS tables into Oracle? What about
loading the data into Oracle 9i and then copying it to the system using
Oracle 10g?

You state: "We are utilizing an Oracle 8i client which is showing signs of
incompatability with our Oracle 10g databases (oracle errors, incorrect
metadata)." That sounds like an Oracle, not a SAS problem. My experience
with Oracle is that the take considerable effort to make their versions
backward compatible, i.e. that Oracle 8i tables work on Oracle 10g and vise-
versa.

I am interested in learning more precisely how you are using SAS and Oracle
on the OpenVMS platform.

Mike