Is it possible that the parameter is not recognized because of the long query line? ORA-00937: not a single-group group function

[jejecrunch]

I ran the following query and got the error ORA-00937: not a single-group group function in mybatis, but not in toad. I don't know how it works or why I get this error only in mybatis.

SELECT CASE WHEN GROUPING(D(#{parameter}, E, F)) + GROUPING(B) = 2 THEN 'TOTAL' ELSE THEN NAME, ...
FROM CDB
WHERE ...
GROUP BY D(#{parameter}, E, F), B, ...

※ ... means many columns.

When I run it, the query line count seems to be between 100 and 200 lines, and I was wondering if this could be caused by a long query.

[harawata]

Hello @jejecrunch ,

I get this error only in mybatis.

This seems highly unlikely.
Have you tried executing the same query using pure JDBC code (with java.sql.PreparedStatement)?
Tools like sqlplus or SQL Developer do not use JDBC API, so you have to write pure JDBC code when comparing behavior in MyBatis.