It seems simple enough, but it's not working for me. If anyone can help with the syntax to make this work, i'd really appreciate it:

File(s):
"DataExtract-20051231.txt"
"DataExtract-20051222.txt"
"DataExtract-20051208.txt"

Contents of a file could be:

34 John A.Smith jasmith Engineer
23 Jim P.Johnson jpjohnson Developer
43 Bob D.User bduser King


Lets say

The First 4 characters are: Age
Next 5: First name
Next 2: Middle Initial
Next 8: Last name
Next 10: Username
Last 9: Title.

I have a table... my_table with the fields:
AGE
F_NAME
M_NAME
L_NAME
U_NAME
TITLE


How do I put the data from all of these data files into the table using a PL/SQL script? Any ideas?

Thank you!