Forum Discussion

Szymon's avatar
Szymon
New Contributor II
5 years ago
Solved

Oracle Insert - multiple rows in transaction possible?

Hi,

How to insert multiple rows at a time into Oracle table within one transaction?
Example:
Reading 10 lines from CSV/Excel file.
Insert 10 lines into Oracle using Oracle insert.
When one of the lines throws an error, none of the lines shall be written.
A classical rollback mechanism.
How to do that?

kind regards
Simon

  • tlikarish's avatar
    tlikarish
    4 years ago

    Ah, sorry, misunderstood the requirement.

    In that case, you could do something like this:

    $email.split(',')[0] → primary
    $email.split(',').slice(1).join(',') → secondary

    Here’s an example pipeline to play around with if it’s helpful.

    split-example_2022_04_06.slp (4.9 KB)