I just test it use hsqldb, it's OK, but change to oralce, It's faild.

hsqldb generate sql is: SQL: select price0_.id as id1_0_, price0_.bustype as bustype2_0_, price0_.status as status3_0_ from Price price0_ where price0_.status=? and locate(?, ((?||price0_.bustype)||?))-1>=?

but oracle generate sql is :SQL: select pricecatal0_.id as id1_62_, pricecatal0_.update_by as update_10_62_, pricecatal0_.update_time as update_t2_62_, pricecatal0_.version as version3_62_, pricecatal0_.added_fee as added_fe4_62_, pricecatal0_.business_types as business5_62_, pricecatal0_.effective_date as effectiv6_62_, pricecatal0_.licence_id as licence11_62_, pricecatal0_.other_fee as other_fe7_62_, pricecatal0_.service_id as service12_62_, pricecatal0_.source_type as source_t8_62_, pricecatal0_.status as status9_62_ from LFB.price_catalogue pricecatal0_ where pricecatal0_.status=? and instr(?||pricecatal0_.business_types||?,?)-1>=?