Skip to Content
0
Former Member
Sep 10, 2007 at 03:22 PM

Sender JDBC with Stored Procedure or Function

45 Views

Hi.

I have a problem to update a row that I obtain from sender JDBC (using SELECT or calling to a FUNCTION).

As the consultation is so complex and the table has fed up transactions, often it takes the registry “A” and updates register “B”.

Try to use the level of transaction “Serializable” (/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter) but it throws the following error to me:

"The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-08177: can't serialize access for this transaction '. For details, contact your database server vendor."

Try to invoke to a function (/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter) but when placing a sentence of UPDATE within the function throws an error, I reviewed to me and calling to a function from a SELECT, Oracle it does not allow to modify registries of the database.

Some other suggestion?