Read tab delimited .txt-file
690818Apr 20 2009 — edited Apr 20 2009Hi,
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.