Intermittent Error JBO-27122 and "Missing IN or OUT parameter at index: ..."
Last updated on AUGUST 04, 2016
Applies to:Oracle JDeveloper - Version 10.1.3.0.4 to 10.1.3.2.0 [Release Oracle10g]
Information in this document applies to any platform.
You have developed an application with JDeveloper 10.1.3.1.0, 10.1.3.2.0 or 10.1.3.3.0
End-users complain about intermittent errors 'Missing IN or OUT parameter at index:'.
JBO-27122: SQL error during statement preparation
Missing IN or OUT parameter at index: <number>
You can reproduce the issue at will in your Development environment by switching off the Application Module pooling for the ADF Business Components (jbo.ampool.doampooling=false), as explained in this note:
<Note:417546.1> How To Reproduce Problems Related to AM Passivation / Activation
the corresponding blog "Set jbo.ampool.doampooling=false to Reproduce Problems Related to AM Passivation / Activation"
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