Error "GetSQL Bind number 6 greater than number of input parameters. (2,600)" in Attachments Store Keys page
(Doc ID 2582351.1)
Last updated on JANUARY 29, 2021
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When adding store key with a date type field type in Attachments Store Keys page, the following PeopleCode error appears:
Error GetSQL Bind number 6 greater than number of input parameters. (2,600). PNM_HR_ATTACHMENTS.Attachment_UI.OnExecute Name:ExistAttachments PCPC:5471 Statement 93
Called from:PNM_DERIVED_HS.PNM_ATTACH_PB.FieldFormula Statement:19
During the binding of input values into the SQL statement, a bind number in the SQL statement was larger than the input parameters.
The issue can be reproduced at will with the following steps:
1. Set Up HCM > Common Definitions > Attachments > Configure Keys >Configure Keys
2. Click on Attachments Store Keys page to enter store key values.
4. Add a Store key record with a date type field
5. Click OK.
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