This discussion is archived
6 Replies Latest reply: Oct 29, 2013 8:23 AM by rp0428 RSS

Oracle Stored Procedure to load pipe delimited files

cf8e1cb9-aed1-45b3-8e5a-ff2276884b9d Newbie
Currently Being Moderated

Hi,

Can anyone help out with an Oracle Stored Procedure to load pipe delimited files into an Oracle table?

The file will have a definite pattern- e.g., FilenameMMDDYYYY.dat

and will be needed to be loaded daily.

Legend

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