|Subject:||problem with executing DELETE statement|
I have a program using DBD::JDBC that executes a particular statement against an Oracle database. The statement looks like this: DELETE FROM tabA WHERE EXISTS (SELECT 1 FROM tabB WHERE tabA.aID = tabB.aID AND tabB.accountName IS NULL) When run with DBD::JDBC version 0.71, you get this error: operation not allowed but with version 0.70, it works just fine. The attached file contains a sample schema that exhibits the problem, along with test programs that show the success with version 0.70 and the failure with version 0.71. I've been testing this against Oracle XE installed on Ubuntu 9.04 Linux.
Message body not shown because it is not plain text.