I have a table with columns [FileId, FileName, FileUrl]. 
I get FileName and FileUrl as comma separated string (v\_FileName, v\_FileUrl) in input params of my INSERT stored proc and FileId is auto increament.
Records insert successfully for FileName if I use regexp\_split\_to\_table single time as follows:

```
    INSERT INTO MYTABLE
    SELECT nextval('mytable_fileid_seq'),
    ,regexp_split_to_table
    ,'testurl'
   FROM regexp_split_to_table(v_FileName, E',')

```

This successfully inserts rows for all filenames in the v\_FileName param and set 'testurl' for fileurl as in above test script.

My query is, is it possbile to set FileUrl as well using regexp\_split\_to\_table for v\_FileUrl param also in such single go ? I tried but it gave error "regexp\_split\_to\_table is used more than once" kind of error. *(May be I am not using it properly.)*

Or suggest me any other way to insert records with such input params. 

Thanks in advance.