This discussion is archived
9 Replies Latest reply: Oct 26, 2012 5:25 AM by drama9346 RSS

Import txt file in to application

Milos Newbie
Currently Being Moderated
Hi All!


In my apex application needs to import data files, through end users. The fields in this file are not separated by any character (structure is not classic CSV), but have a fixed width.

How to do?

Scenario 1:

import file to a temporary table with a blob column, create a trigger for this table via a PL / SQL code meet end table

Scenario 2:

using DBMS_LOB libraries to read directly file

Scenario 3:

?

Milos.

(Apex 4.1.0.00.32, db:10.2.0.4 )

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points