ODB_VARIANT_AGG_UTIL.REBUILD_AGGREGATES Procedure Fails with ORA-06550 in Exadata Environment (Doc ID 2145095.1)

Last updated on JUNE 10, 2016

Applies to:

Oracle Healthcare Omics - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

On : Oracle Healthcare Omics - TRC 3.1 version, Omics Data Model issues

When attempting to execute ODB_VARIANT_AGG_UTIL.rebuild_aggregates procedure, the following error occurs:

ERROR
-----------------------
Ora-06550: line 3, column 35: PLS-00103: Encountered the symbol "END" when expecting the following: :=.( %; The symbol ";" was substituted for "END" to continue.

Cause

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