TOraLoader Class

TOraLoader allows to load external data into the server database.

For a list of all members of this type, see TOraLoader members.

Unit

OraLoader

Syntax

TOraLoader = class(TDALoader);

Remarks

TOraLoader serves for fast loading of data to the server. It uses direct path load interface to speed up loading. To specify the name of the loading table set TDALoader.TableName property. Use TDALoader.Columns property to access individual columns. Write TDALoader.OnGetColumnData or TDALoader.OnPutData event handlers to read external data and pass it to the database. Call TDALoader.Load method to start loading data.

Limitations and Restrictions

TOraLoader has the following limitations similar to those of SQL*Loader:

• triggers are not supported
• check constraints are not supported
• referential integrity constraints are not supported
• clustered tables are not supported
• loading of remote objects is not supported
• user-defined types are not supported
• LOBs must be specified after all scalar columns
• LONGs must be specified last
• You cannot use TOraLoader in a threaded OCI environment in direct mode with Oracle client 8.17 or lower.
• ODAC sets T:Devart.Odac.Units.OraCall := False when you use OraLoader unit in your application. You can set it to True for Oracle client 9.2 or higher.

Inheritance Hierarchy

TDALoader
   TOraLoader

See Also

• TOraLoader Component
• TDALoader
• TQueueAgents
• TOraSession