Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Read tab delimited .txt-file

690818Apr 20 2009 — edited Apr 20 2009
Hi,

I'm trying to read a tab delimited .txt-file into my database. I have made an change in the script I found on [http://advait.wordpress.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/]. This script was meant to read .csv files (which works fine). So I changed the line

v_line := REPLACE (v_line, ',', ':');

into

l_line := REPLACE (l_line, CHR(9), ':');

But when I run the script the data doesn't get inserted into my tables. I don't get any error as well.

Does anyone have any idea why this is?

Thanks in advance,

Bram.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2009
Added on Apr 20 2009
6 comments
973 views