OraFAQ Forum: Forms » Read Exteranal file Data at a time like bulk collect concept

Home » Developer & Programmer » Forms » Read Exteranal file Data at a time like bulk collect concept (Form 6i/10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Read Exteranal file Data at a time like bulk collect concept [message #561498]

Mon, 23 July 2012 06:00

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi Friends,

I have external file like (.csv or .txt) which contain million of record...i wnat to upload it in backend by using form 6i/10g.

by using package text_io.fopen i read it and by using for..loop conventional method insert record into table...but it will take time..

Is there any way like we use bulk collect and FORALL in backend for inserting data into table..

Is there any way to read external file at a time and insert it ...so minimize inserting time....process will become fast.

Thanks...

Report message to a moderator