cancel
Showing results for 
Search instead for 
Did you mean: 

Passing the XML payload to the cursor in the Oracle Database

Former Member
0 Kudos

Hi Experts,

I am trying to insert multiple records in the table of oracle database. I am sending 5000 records per message. I am using a stored procedure to insert the records. I want to make a single call to the stored procedure and insert all the records.

I dont want to call SP for each record.

Please suggest the way to implement this (Using Cursor/Loop) .

Thanks

Ajay

Accepted Solutions (1)

Accepted Solutions (1)

dharamveer_gaur2
Active Contributor
0 Kudos

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ajay,

You can use BPM-Collect Payload pattern to implement your scenario.

Collect some 100 messages and then call your SP.This may help you.

thanks

Prabhakar