'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:

Symptoms

On : 11.2.0.27 version, Policy information

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

ERROR
-----------------------
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


STEPS
-----------------------
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.

Cause

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