Can I load a CSV into a stored procedure that inserts into multiple tables?
Here is my thought:


Create a table with all the fields that exist in the csv file.
Create a trigger (After insert on the table created in step 1) that calls your procedure that you already have, or let the trigger itself insert new values to the corresponding tables.
Load the CSV file to the table you created in step 1
The other tables will be populated automatically (Nothing to do here)
Drop the table that you created in step 1