If you have to create a stored procedure in your PlayFramework Database Evolution Script, make sure to properly escape your semicolons (by using two semicolons):
If you run into the error “ORA-01795 maximum number of expressions in a list is 1000”, you’ll probably created a query that has to many elements in the IN-clause. To fix it, use the provided helper class to issue multiple queries with less than 1000 elements.