Chapter 21

File Exchange Solutions: SQL*Loader, PL/SQL, and Pro*C

Serg Shestakov

Dmitry Petrov

A very important aspect of any large information system is how it handles diverse and complex file exchange procedures. Interfaces to external files can play a key role in many areas (for example, when migrating to Oracle from legacy systems or supporting international standards such as Visa or Europay). In addition to the complexity associated with application logic, there are strong requirements for file exchange solutions to be fast, secure, and reliable. When data is stored in Oracle database, developers can rely on three basic Oracle tools when designing and implementing file exchange solutions: SQL*Loader, PL/SQL, and Pro*C. This chapter discusses ...

Get Oracle Internals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.