Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLException: Missing IN or OUT parameter at index:: 2

Eugen LangNov 30 2022

Hey everybody! I am creating an app in jdeveloper version 12.2.1.0.0
When the sql request is executed, there is such an error in the logs. Help, I can not understand what is the problem?
oc.pngsql.png

This post has been answered by Eugen Lang on Dec 1 2022
Jump to Answer

Comments

ORASCN

May I know what kind of sessions are timed out?
Regards,
Veera

User51642 Yong Huang

I mean the web pages, e.g.:
h t t p : / / ouroggserver : 9100
h t t p : / / ouroggserver : 9101
(community.oracle.com tells me "You have to be around for a little while longer before you can post links" so I put spaces in the URLs)

ORASCN

That is expected. If you are not using the session for a longer time or the session is not active for a longer time, then surely it will get timed out. This is for the security reasons.
Regards,
Veera

User51642 Yong Huang

Anybody has an idea? I suspect not many people use MA so they don't use the web interface? This timeout setting doesn't seem to be documented anywhere.

Martin Maes

I have the same problem. Security people think that administrators use one screen at the time and don't leave it until they are done. In reality, we use different screens, get interrupted, go back again and find the screen or GUI locked. This happens several times a day and is not so helpful (although very secure :-) )

ORASCN

I kind of explored it, but couldn't find any options to set the timeout. It's default I believe as I already mentioned.
Regards,
Veera

User51642 Yong Huang

Thank you! In case you all have an idea about another annoying feature: Is there a way to prevent the login screen username and password pane from moving from the right of the screen to the left?

ORASCN

I have read the full message before it was edited
May be an SR can be opened and suggest the changes.

Regards,
Veera

1 - 8

Post Details

Added on Nov 30 2022
2 comments
9,518 views