Passing the XML payload to the cursor in the Oracle Database
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) .