My Oracle Support Banner

OLAP QUERY FUNCTIONALITY ISSUE (Doc ID 964744.1)

Last updated on NOVEMBER 07, 2022

Applies to:

Oracle OLAP - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

The following command:
select * from table(olap_table('<owner>.<aw_name> duration session', '', '', 'dimension "sysclass" from sysclass'))
returns 203 rows with text in an Oracle 11.1.0.7 database.

However the equivalent command on 11.2.0 1 returns 203 blank rows (several hundred characters wide)
select * from table(olap_table('<owner>.<aw_name> duration session', '', '', 'dimension "sysclass" from sysclass'))


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.