Just thinking a bit more, if you are using 8i, you could use PL/SQL to read
the file, and insert into a table of type GLOBAL TEMPORARY, and then just
fetch from the table in a single array operation. Probably be much lighter
on the network. However, same caveats apply as to the entry in the
initxxx.ora file. The benefits of using a GLOBAL TEMPORARY table is that
they are session specific (ie if you have multiple sessions, they dont lock
each other out, or see each others data), and they don't generate redo logs,
do are 'lighter' to populate than regular tables.
Steve
