> i think i need on demand with my app

You can either read in the data yourself into a program in your
favourite language and insert one at a time, or use some data pumping
tool (which is doing exactly the same thing under the hood), or write a
program to massage the csv into the structure of an external table then
do a insert into table (blah) values (select blah from external table).

Adam