Forum Stats

  • 3,839,156 Users
  • 2,262,456 Discussions
  • 7,900,869 Comments

Discussions

OBI EE: Interval data type - Unsupported data type 190 error

Hi,
We have fields of type interval day to seconds. When I import this table to BI and the field is UNKOWN type. I set it to INTERVAL When I query this field I get error: [nQerror : 17003] Oracle gateway error: Unsupported data type 190.

Is there any way how to use INTERVAL data type? Of course we can change data type in DB or use view with a conversion, but we don't want to do it.

Thanks
Tagged:
This discussion has been closed.