Date: Mon, 29 Aug 2005 10:11:56 -0700
Reply-To: "email@example.com" <dmbuffum@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "firstname.lastname@example.org" <dmbuffum@GMAIL.COM>
Subject: Re: SAS/ACCESS ORACLE: Timestamp datatype not supported
Content-Type: text/plain; charset="iso-8859-1"
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
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.