We're updating the issue view to help you get more done. 

Return REFCURSOR on native named query: regression on 4.2.0 CR1

Description

After upgrade from 4.1.9 to 4.2.0.CR1 this native query shows an ORA-:

1 2 [SqlExceptionHelper ] [15:17:59.846] [http-thread-pool-8080(5)] WARN - SQL Error: 17166, SQLState: 99999 [SqlExceptionHelper ] [15:17:59.847] [http-thread-pool-8080(5)] ERROR - No se puede realizar la recuperación en una sentencia PLSQL: next

Code of the native named query:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 @NamedNativeQueries({ @NamedNativeQuery( name = NamedQueryIdentifiers.RESERVAS_LISTADO_PANTALLA, query = " { call GNOMO.PCK_RESERVAS.LISTADO_PANTALLA(?, " + " P_FILTRO => GNOMO.FILTRO_LISTADO_RESERVAS( " + " FECHA_RESERVA_INI => :fechaReservaIni, " + " FECHA_RESERVA_FIN => :fechaReservaFin, " + " AULA_ID => :aulaId, " + " CENTRO_ID => :centroId, " + " CAFETERIA => :cafeteria, " + " ESTADO => :estados, " + " SOLICITANTE => :solicitante, " + " RESPONSABLE_AULA => :responsableAula " + " ), " + " P_PAGINACION => COMUN.PAGINACION(" + " INICIO => :" + NamedQueryParameters.PAGINACION_INI_PARAM + ", " + " LIMITE => :" + NamedQueryParameters.PAGINACION_FIN_PARAM + " ), " + " P_ORDENACION => :" + NamedQueryParameters.ORDENACION_PARAM + " ) " + " } ", resultClass = FilterResult.class, callable = true ) })

The first ? is the REFCURSOR that returns the database store procedure.

Environment

Databas: Oracle 11g
Hibernate: 4.2.0.CR1

Status

Assignee

Lukasz Antoniak

Reporter

Marcial Atiénzar Navarro

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

4.2.0.CR1

Priority

Major