IllegalStateException: incorrect_query_for_execute_update Is Thrown When Insert/update To Stored Procedure In Entity Class
(Doc ID 2586329.1)
Last updated on OCTOBER 08, 2024
Applies to:
Oracle WebLogic Server - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
IllegalStateException is thrown when EJB application try to insert/update record to DB through stored procedure. But Different behavior existed when deploying same application EAR on WLS 11G and 12C.
No problem when retrieve data from DB through stored procedure
No problem when insert/update record in 11G ,but not work in 12C
The following coding is tested.
1. Query q = em.createNamedQuery()
q.executeUpdate();
=> exception is thrown
2. EntityManager em;
em.persist();
=> record can be inserted
q.executeUpdate();
=> exception is thrown
2. EntityManager em;
em.persist();
=> record can be inserted
Below is the complete stack trace observed:
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |