Rob Spoor wrote:I'm only guessing here, but I don't think it's possible to call a function like it was a stored procedure. In MS SQL Server it's certainly not allowed.
It
should work. It definitely works in Oracle. Actually, this is why escaping (the curly braces) must be used, it allows the JDBC driver to rewrite and process the query as required by its database.
However, your advice is certainly worth to try, if the direct call doesn't work with MS SQL, other databases might be affected too.