Author: steve.ebersole(a)jboss.com Date: 2006-08-21 10:49:32 -0400 (Mon, 21 Aug 2006) New Revision: 10301 Modified: branches/Branch_3_2/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java Log: HHH-2017 : locate function on Oracle Modified: branches/Branch_3_2/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java =================================================================== --- branches/Branch_3_2/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java 2006-08-21 14:48:38 UTC (rev 10300) +++ branches/Branch_3_2/Hibernate3/src/org/hibernate/dialect/Oracle9Dialect.java 2006-08-21 14:49:32 UTC (rev 10301) @@ -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() );