Skip to Content
0

JDBC sender oracle stored procedure with both insert and update together

Nov 16, 2016 at 09:43 PM

17

avatar image
Former Member

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 -

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers