[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3682) OracleDialect with oracle 11g

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3682?page=c... ] Richard Marriott commented on HHH-3682: --------------------------------------- As far as I can tell, the problem is still there with hibernate 3.3.2.GA: As far as I can tell this is still a problem. I am using Hibernate 3.3.2.GA with WebLogicServer 10.3 - this is an upgrade from a working Hibernate environment in WLS 8.1 The SQL and HQL procedures still work, but trying to call an Oracle stored procedure or function which returns a sys_refcursor fails, whatever the Dialect setting in the hibernate cfg file: This is causing real grief - is there a fix? 7672 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG jdbc.AbstractBatcher - 2010-03-15 21:18:08,192 about to o pen PreparedStatement (open PreparedStatements: 0, globally: 0) 7694 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG hibernate.SQL - 2010-03-15 21:18:08,214 { ? = call ninjad evmain.reference_tables.get_error_codes() } 7995 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG jdbc.AbstractBatcher - 2010-03-15 21:18:08,515 about to c lose PreparedStatement (open PreparedStatements: 1, globally: 1) 8011 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG util.JDBCExceptionReporter - 2010-03-15 21:18:08,531 coul d not execute query [{ ? = call ninjadevmain.reference_tables.get_error_codes() }] java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 18: PLS-00382: expression is of wrong type ORA-06550: line 1, column 7: PL/SQL: Statement ignored at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source) at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source) at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source) at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source) at weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source) at weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source) at weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98) at org.hibernate.dialect.Oracle8iDialect.getResultSet(Oracle8iDialect.java:437) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:215) at org.hibernate.loader.Loader.getResultSet(Loader.java:1809) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) at no.netcom.ninja.core.system.persistence.QueryNinja.fullQuery(QueryNinja.java:1504) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira