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.
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.