Skip to Content
0
Former Member
Nov 16, 2016 at 09:43 PM

JDBC sender oracle stored procedure with both insert and update together

48 Views Last edit Nov 16, 2016 at 10:21 PM 2 rev

Hello -

I've used the following blog

https://archive.sap.com/discussions/message/16245389

for developing a PL/SQL procedure to fetch the records. However updating the table with pragma autonomous is giving me problems.

I'm not an expert in Pl/SQL . I need the code on how to pass the ref cursor to the update procedure to update only the selected records.

Thanks for your help!

Pat -