Friday, 2 December 2011


Direct DB Request and Integer Problem on Column Selected

Sometimes when you do a direct database Request especially from Oracle you have problems when a number to obiee is an integer

Do the below to resolve .. In your sql statement CAST(yourcolumn AS double precision)

To change integer into double precision ---

select CAST(yourcolumn AS double precision)
from Yourtable

Blog Archive

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts