Re: SQL: Oracle-MSAccess data type error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 11 Aug 2002 17:42:00 +0200
Message-ID: <bb1dlusqoc45se2r8klu73td38hibo00bq@4ax.com>

On Sun, 11 Aug 2002 14:08:23 GMT, Dave <dgmoore_at_erols.com> wrote:

>When I attempt to use Oracle nvl or decode functions on date fields in
>pass-through queries from Access 2K the Jet error "Invalid precision for
>
>decimal data type" is returned. This happens with both ODBC and ADODB
>connections to the table in question. A check of the table fields
>verifies the data type to be date/time. I have tried various
>combinations and permutations of TO_DATE and TO_CHAR on these fields
>with no success.
>
>Does anybody have any suggestions?
>
>Thanks
>Dave
>
>

You need to post versions of Oracle and the various drivers to get any useful response to this question, or people to reproduce your problem. Nobody here is clairvoyant.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Aug 11 2002 - 10:42:00 CDT