Multiple rows insert in CPQ Data Tables
Summary:
Multiple rows insert in CPQ Data Tables
Content (please ensure you mask any confidential information):
I would like to insert multiple records at once using bmql Insert statement.
As per Oracle documentation, inserting multiple rows syntax would look like this:
results = bmql("insert into TABLE_NAME (CHILD_DOC_NUMBER,PARENT_DOC_NUMBER,TRANSACTION_ID,NUMBER) values (1, 11,22,'06343534'),(2,67,34,'24252433')");
My values are not static, they are coming from variables. I was thinking to construct in BML a string variable that would hold the values (formatted as indicated above),
and then use that variable, with all the values, to perform the insert. I had tried two options (listed below) but both ended up in error.