My Oracle Support Banner

Oracle Analytics - Use of LISTAGG Function Returns Error "ORA-30488: argument should be a @ function of expressions in PARTITION BY at OCI call OCIStmtExecute" (Doc ID 2704005.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

LISTAGG function used in the column formula of Oracle Analytics Server

When you execute the report, it's failed with error message below:

Error detail : ORA-30488: argument should be a function of expressions in PARTITION BY at OCI call OCIStmtExecute. (HY000)

Changes

 Upgrade OBIEE from 11.1.1.9 to Oracle Analytics Server

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
References


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