I have data formatted the following way in a delimeted file (this is a
watered down version to simplify my question):

FirstName|LastName|Phone1,Phone2,Phone3...PhoneN

where there can be multiple Phone Numbers separated by a comma (while
the rest of the data is separated by a '|').

The new data structure separates out phone number so there can be as
many numbers for each person.

Person
--------
PersonID
FirstName
LastName
....

Phone
-------
PersonID
PhoneNumber

What I would like to do is use SQL Loader to pull in the data, and
then when it hits the list of Phone numbers, to call a function that
will loop over the string and put the phone numbers into normalized
records, however, I do not know if SQL Loader can handle it. I can
always do some sort of temp table to get the data loaded, and then
script the rest, but I'd like to know if SQL Loader can do it.