I am trying to execute a stored proc with hibernate named query. I want to pass the oracletypes as the type since I am getting this exception.
org.hibernate.HibernateException: Problem while trying to load or access OracleTypes.CURSOR value.
As a workaround I am trying to use createsqlquery but I think I am doing something wrong in passing the oracle cursor type.
Any thoughts, ideas.?
When using this way I am getting the below exception:
org.hibernate.QueryParameterException: could not locate named parameter