I have a java application on java Swing, EJBs, Bea WebLogic, and Oracle.

When I run a long query in batch, I get this message:

java.sql.SQLExc eption: Oracle cannot handle batched SQL > 64k bytes

but when I copy that query in PL/SQL developer, there is no problem.

Whats the limitations in batch execution of sql statements. kindly help me.