Eu estou fazendo a migração de um sistema que era 9i(jdev) para o 10g e estou tomando o erro abaixo sempre que tento inserir, deletar ou dar update em alguma coisa. Mas no ambiente local ou no servidor aqui na empresa, o sistema está rodando normalmente. Quando ponho pra rodar no ambiente do cliente que o erro acontece.
oracle.jbo.DMLException: JBO-26041: Failed to post data to database during “Update”: SQL Statement “BEGIN UPDATE TABLE Rxearint SET FIELD1=:1,FIELD2=:2,FIELD3=:3,FIELD14=:4,FIELD15=:5,FIELD1=:6,FIELD7=:7,FIELD8=:8 WHERE FIELD9=:9 RETURNING FIELD1, FIELD2, FIELD3, FIELD4, FIELD5, FIELD6 INTO :10, :11, :12, :13, :14, :15; END;”.
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:49
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5413)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4235)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2937)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:274
at br.com.sys.app.controller.AppDBTransactionImpl.postChanges(AppDBTransactionImpl.java:2
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1922)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2115)
at br.com.sys.app.controller.AppUpdateAction.execute(AppUpdateAction.java:47
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at br.com.sys.app.controller.AppActionServlet.process(AppActionServlet.java:123)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:20
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:125)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
Detail 0
java.sql.SQLException: ORA-06550: line 1, column 14:
PLS-00454: with a returning into clause, the table expression cannot be remote or a subquery
ORA-06550: line 1, column 7:
PL/SQL: SQL Statement ignored
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:790)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2901)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2973)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4145)
at com.evermind.sql.PreparedStatementBCELProxy.executeUpdate(PreparedStatementBCELProxy.java:46)
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:356)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5413)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4235)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2937)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:274
at br.com.sys.app.controller.AppDBTransactionImpl.postChanges(AppDBTransactionImpl.java:2
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1922)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2115)
at br.com.sys.app.controller.AppUpdateAction.execute(AppUpdateAction.java:47
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at br.com.sys.app.controller.AppActionServlet.process(AppActionServlet.java:123)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:20
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:125)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
Alguém tem alguma idéia para me dar?