"QueryException: Dialect [org.hibernate.dialect.OracleDialect] not known to support REF_CURSOR parameters" in EAP
Issue
- Using the Hibernate dialect
org.hibernate.dialect.OracleDialect -
Encountering a failure when executing a stored procedure with an
OUTparameter of typeREF_CURSOR... org.hibernate.QueryException: Dialect [org.hibernate.dialect.OracleDialect] not known to support REF_CURSOR parameters at org.hibernate.procedure.internal.StandardCallableStatementSupport.verifyRefCursorSupport(StandardCallableStatementSupport.java:76) at org.hibernate.procedure.internal.StandardCallableStatementSupport.renderCallableStatement(StandardCallableStatementSupport.java:59) at org.hibernate.procedure.internal.ProcedureCallImpl.buildOutputs(ProcedureCallImpl.java:384) at org.hibernate.procedure.internal.ProcedureCallImpl.getOutputs(ProcedureCallImpl.java:363) at org.hibernate.jpa.internal.StoredProcedureQueryImpl.outputs(StoredProcedureQueryImpl.java:234) at org.hibernate.jpa.internal.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:217) ...
Environment
- Red Hat JBoss Enterprise Application Platform (EAP) 7
- Hibernate 5
- Oracle 11, 12
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.