My Oracle Support Banner

'SQLException:Prepared Or Callable Statement Has More Than 2000 Parameter Markers' Warning Message During Policy Search (Doc ID 2951600.1)

Last updated on MAY 26, 2023

Applies to:

Oracle Insurance Policy Administration J2EE - Version and later
Information in this document applies to any platform.


On : version, Policy information

When attempting searching on Policies using wildcard,
the following error occurs.

SQLException: Prepared or callable statement has more than 2000 parameter markers. Error Code: 0 Call: SELECT authProductPageField.fieldName, MAX(authProductPageField.securityLevelCode) FROM AsAuthProductPageField authProductPageField INNER JOIN ( SELECT subQry1AuthProductPageField.fieldname AuthFieldName, COUNT(subQry1AuthProductPageField.securitylevelcode) AuthFieldDefinitionCount FROM AsAuthProductPageField subQry1AuthProductPageField INNER JOIN AsAuthProductPage subQry1AuthProductPage ON subQry1AuthProductPage.authProductPageGuid = subQry1AuthProductPageField.authProductPageGuid INNER JOIN AsAuthPage subQry1AuthPage ON subQry1AuthPage.authPageGuid = subQry1AuthProductPage.authPageGuid INNER JOIN AsAuthProduct subQry1AuthProduct ON subQry1AuthProduct.authProductGuid = subQry1AuthProductPage.authProductGuid INNER JOIN AsPlan subQry1AsPlan ON subQry1AuthProduct.productGuid = subQry1AsPlan.productGuid WHERE subQry1AuthPage.pageName = ? AND subQry1AsPlan.planGuid = ? AND ( subQry1AuthProduct.authCompanyGuid IN

The issue can be reproduced at will with the following steps:
1. Login to OIPA with the user which is included in at least 10 Security Groups.
2. Perform a search for Policies using wildcard. Search can be %123 or %1234%.
3. DB should have at least 15 Policies matching search string with wildcard.


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

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