Skip to Content
0
May 13, 2010 at 10:36 PM

JDBC sender - Processing

31 Views

Hi All,

For JDBC sender, query is SELECT * FROM CERT.CERTIFICATION WHERE ROW_STATUS IN ('D', 'I', 'U') AND ROWNUM = 1.

And UpdateSQL Statement has CALL CERTIFICATION.SAP_CLEANUP.CLEANUP().

The update SQL statement is for calling a procedure "CERTIFICATION.SAP_CLEANUP.CLEANUP()" in Oracle side for setting the ROW_STATUS back to initial flag which is 'A' means should not pick by PI JDBC adapter.

So, whenever a record is selected from the certification table, we have to update the flag row_status back to 'A'.

Here, we are facing an issue. Sometimes, the call procedure statement is updating some other row and that record will not be processed by PI. It's very difficult to debug and find the solution as it happens only sometimes.

Is there any other way to update the row_status of the record which got picked up by PI.

Appreciate!!!

-Mike