Yes, using sub process for such scenario would be inefficient code. Can you let us know what exact is the use case where you are trying to insert data to? And where is the data read from?
Options we have is to use JDBC connector or OData or Data Access service. If you can let us know the use case, we can help you with suggestions.
Thanks & Regards
Hi John ,
As suggested by Divya ,you can write any complex query example
INSERT INTO table2
SELECT * FROM table1
And use it in data access service (BPEL process) to achieve it.
Or write a stored procedure which can take input a file for all insert statements and execute it in one go.
Then use the stored procedure call .
How to call data access in CAI .