I was using SQLServer.
Now i am migrating it to Oracle.
I need to do bulkinsert from a text file into a Table.
in SQLServer there was bulkinsert command.
In oracle i tried UTL package.But it was very slow.
I tried SQLLoader in CMd prompt it was quite fast.
But how to use inside my procedure.
Ie. calling thesqlloader from inside my procedure.
Is there any way of doing it.
You can run SqlLoader (or any other executable)
from within Oracle using ExtProc Listener.
If you have 9i you can use External tables feature, which
allows to manipulate data without loading it into DB.
can you explain about how to use it .B'cos i am not familiar with it.
Click Here to Expand Forum to Full Width