Column defined as NUMBER(0,0) seems to be causing problems
582751Feb 5 2009 — edited Feb 9 2009Hi,
I'm having some issues consuming Oracle data in a 3rd party app and I'm hoping someone here can help out.
I have a query that, when run, returns a different answer in my Oracle query tool (i.e. SQL Navigator) than it does in a third party app (e.g. Excel) that is consuming the results via a driver. The query returns one row and the problems are with 2 columns in particular that simply return zero when I know from SQL Navigator that that is wrong - they should be 3363528 & -132000.29.
I have taken a look at those 2 columns - they are in a view and have datatype NUMBER(0,0). That started my alarm bells ringing because a number that has no precision or scale seems rather strange to me.
Of course, NUMBER(0,0) may be a red herring but its the best avenue of investigation that I hae right now!
Can anyone (a) hazard a guess as to why a column might get exposed as NUMBER(0,0) and (b) explain why it returns a different result depending on where I execute the query.
Thank you in advance
Jamie Thomson