Issue Type: Bug Bug
Affects Versions: 4.2.0.CR1
Assignee: Unassigned
Components: query-sql
Created: 20/Feb/13 6:47 AM
Description:

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

[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:

@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
Project: Hibernate ORM
Priority: Major Major
Reporter: Marcial Atienzar
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira