Author: steve.ebersole(a)jboss.com Date: 2006-08-21 10:48:38 -0400 (Mon, 21 Aug 2006) New Revision: 10300 Modified: trunk/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java Log: HHH-2017 : locate function on Oracle Modified: trunk/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java =================================================================== --- trunk/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java 2006-08-19 11:31:11 UTC (rev 10299) +++ trunk/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java 2006-08-21 14:48:38 UTC (rev 10300) @@ -115,7 +115,7 @@ registerFunction( "translate", new StandardSQLFunction("translate", Hibernate.STRING) ); registerFunction( "substring", new StandardSQLFunction( "substr", Hibernate.STRING ) ); - registerFunction( "locate", new StandardSQLFunction( "instr", Hibernate.INTEGER ) ); + registerFunction( "locate", new SQLFunctionTemplate( Hibernate.INTEGER, "instr(?2,?1)" ) ); registerFunction( "bit_length", new SQLFunctionTemplate( Hibernate.INTEGER, "vsize(?1)*8" ) ); registerFunction( "coalesce", new NvlFunction() );