Search Using CatalogService API Fails with ORA-01795

(Doc ID 1952673.1)

Last updated on OCTOBER 04, 2016

Applies to:

Identity Manager - Version and later
Information in this document applies to any platform.



ORA-01795 maximum number of expressions in a list is 1000

is thrown from database when executing search using CatalogService API.


java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(
    at oracle.iam.catalog.repository.DBRepository.populateTheHierarchicalDataForCatalog(
    at oracle.iam.catalog.util.Utility.getCatalogVoFromResultSet(
    at oracle.iam.catalog.repository.DBRepository.executeFindClosedCatalog(
    at oracle.iam.catalog.repository.DBRepository.findCatalog(
    at oracle.iam.catalog.impl.CatalogServiceImpl.findCatalog(


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