Thanks for the question, Vrishabh.
Asked: August 13, 2019 - 12:26 pm UTC
Last updated: August 15, 2019 - 2:31 am UTC
Version: Database 11.2.0.4
Viewed 1000+ times
You Asked
We are facing an issue, where some of our application processes stop working, While checking the logs, we found out that at this particular time, a common stack trace appears i.e.
org.hibernate.util.JDBCExceptionReporter.logExceptions : Missing IN or OUT parameter at index:: 1
We tried to find out the cause, came to the conclusion, that at this time the SQL queries with Bind Variable Parameter, stops working (somehow server stops binding parameter varaiable value in queries and thus they throw above error).
And when we restart that particular weblogic (10.3.6) server jvm, the application again starts working.
Following is our production database cursor related parameters:
cursor_space_for_time - FALSE
session_cached_cursors - 500
cursor_sharing - EXACT
open_cursors - 4000
cursor_bind_capture_destination - memory+disk
Request you to please help in above issue.
and Connor said...
Unfortunately
Missing IN or OUT parameter at index:: 1
is one of those errors which is a generic "We have a problem doing some binding". The fact it is intermittent suggests a data related issue or a bug in one of the layers.
My suggestion is to enable some tracing at level 4, ie
dbms_monitor.session_trace_enable(binds=>true)
to capture statements and their binds and see if you can catch the error there. If that fails, I think you'll need to log a call with Support, since it seems related to the bounce of WLS
Is this answer out of date? If it is, please let us know via a Comment