Date:         Mon, 29 Aug 2005 10:11:56 -0700
Reply-To:     "dmbuffum@gmail.com" <dmbuffum@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "dmbuffum@gmail.com" <dmbuffum@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: SAS/ACCESS ORACLE: Timestamp datatype not supported
Comments: To: sas-l@uga.edu
In-Reply-To:  <1125329945.136718.198960@g43g2000cwa.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Matt,

The SAS Note quotes the error message, "ERROR: At least one of the
columns in this DBMS table has a datatype that is not supported by this
engine." This sounds like a problem with the SAS/Access to Oracle
LIBNAME engine.

I would attempt to bypass the SAS/Access LIBNAME engine in 9.1.3 with
[Remote] SQL Pass Through. I have used SQL Pass Through to submit
native Oracle SQL*PLUS and PL/SQL queries and retrieve the result set
in a SAS dataset.

Here is a web page with some online references to help craft your
queries in native Oracle SQL.
http://www.onesmartclick.com/programming/oracle.html