Thanks for your reply. This is really helpfull idea.
I am thinking of changing my procedure in order to accept two concatenated strings and add the folowing logic :
- create a typed record array
- split using the regexp_substr function the received strings and insert the data into the typed array. ***
- iterate the array and perform the inserts.
Could this help me ?
Regarding (***) can you provide me with a code snippet how can i achieve this.
This is my code :
TYPE RecordType IS RECORD(
itemId VARCHAR2(100 CHAR),
itemStatusId NUMBER(38));
TYPE WorkListType IS TABLE OF RecordType INDEX BY BINARY_INTEGER;
If i receive two strings like :
str1 = 'item-id01,item-id02,item-id03'
str2 = '4,5,6'
How can i split both strings and insert them into WorkListType ?
so that i have a match between the elements from the two strings.
Thanks.