ORA-942 When Using CUBE_TABLE With Connection Pooling
Last updated on FEBRUARY 14, 2012
Applies to:Oracle OLAP - Version: 126.96.36.199 to 188.8.131.52 - Release: 11.2 to 11.2
Information in this document applies to any platform.
CUBE_TABLE with an object they should be able to see.
This behaviour was noticed in Application Express (APEX) using using Embedded pl/sql gateway - XDB
Shared Server architecture with 2 different users querying their own view that is based on CUBE_TABLE() function defined in their own schema.
The error did not appear to reproduce when using OLAP_TABLE function instead of CUBE_TABLE.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms