How to modify oracle stored procedure for JDBC Receiver Adapter?

[Former Member]

Hi all.

This is Urgent.

Scenario is

SELECT a TABLE with procedure and update column with it,

then send data to SAP System with RFC Adapter.

When I executed a sync bpm, scenario was finished internal error.

Pls, let me know how to correct procedure using JDBC Receiver Adapter?

Regrds all.

-

---

Procedure Code -

---

SET SERVEROUTPUT ON

CREATE OR REPLACE PROCEDURE zwtn2

IS

v_seller_company wtnivhd.seller_company%TYPE;

v_invoice_no wtnivhd.invoice_no%TYPE;

v_report_date wtnivhd.report_date%TYPE;

v_customs_date wtnivhd.customs_date%TYPE;

v_ap_post_date wtnivhd.ap_post_date%TYPE;

v_gr_date wtnivhd.gr_date%TYPE;

CURSOR l_cursor IS

SELECT seller_company,

invoice_no,

report_date,

customs_date,

ap_post_date,

gr_date

FROM wtnivhd

WHERE wtn_send_flag = 'N'

AND rownum < 31

FOR UPDATE;

BEGIN

OPEN l_cursor;

LOOP

FETCH l_cursor

INTO v_seller_company,

v_invoice_no,

v_report_date,

v_customs_date,

v_ap_post_date,

v_gr_date;

EXIT WHEN l_cursor%NOTFOUND;

UPDATE wtnivhd

SET wtn_send_flag = 'Y'

WHERE CURRENT OF l_cursor;

END LOOP;

CLOSE l_cursor;

END zwtn2;

/

[udo_martens · Accepted solution]

Hi Alex,

plz have a look to Runtime Workbench / Adapter Monitoring to find an error message.

Regards,

Udo