Database DataWarehousing (MOSC)

MOSC Banner

bitmap_construct_agg does not accept large NUMBER

edited Feb 21, 2020 1:00PM in Database DataWarehousing (MOSC) 1 commentAnswered

Hi!

19c Documentation states: "BITMAP_CONSTRUCT_AGG is an aggregation function that operates on bit positions and returns the bitmap representation of the set of all input bit positions. It essentially maintains a bitmap and sets into it all the input bit positions. It returns the representation of the bitmap. The argument expr is of type NUMBER. The return type is of type BLOB."

>select banner from v$version;

BANNER                                                                        

--------------------------------------------------------------------------------

Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production

>select bitmap_construct_agg(999999999999) from dual;

Error starting at line : 12 in command -

select bitmap_construct_agg(999999999999) from dual;

Error report -

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center