Re: SQL: Oracle-MSAccess data type error

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<bb1dlusqoc45se2r8klu73td38hibo00bq_at_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

Sybrand,

I am experiencing the exact same problem. A query that works fine in PL/SQL Developer or InfoReports gets this error when running a pass through query in Access 2000 using Oracle ODBC drivers. 'Invalid precision for decimal data type.'

Access 2000 version 9.0.3821 SR-1
Oracle ODBC driver version 8.01.77.0
Oracle Database version 8.1.7.3

This line in the query fails:
NVL(SYSTEM.HEAD_INFO.TAG_CODE, SYSTEM.TAG_STATUS.TAG_STATUS), TAG_CODE is datatype varchar2(12)
TAG_STATUS is datatype varchar2(15)

If I take that one line out the query responds nicely. When I attempted to use DECODE or CASE WHEN I received the same error.

Any help would be greatly appreciated!!!

Sincerely,

Timothy Frawley
tim_frawley_at_fishgame.state.ak.us
Mark, Tag, and Age Laboratory
Department of Fish and Game
State of Alaska Received on Wed Aug 14 2002 - 18:05:12 CDT