Component List

This topic presents a brief description of the components included in the Oracle Data Access Components library. Click on the name of each component for more information. These components are added to the ODAC page of the Component palette except for TCRBatchMove and TVirtualTable components. TCRBatchMove and TVirtualTable components are added to the Data Access page of the Component palette. Basic ODAC components are included in all ODAC editions. ODAC Professional and Developer Edition components are not included in ODAC Standard Edition.

Basic ODAC components

	TOraSession	Lets you set up and control connections to Oracle.
	TOraQuery	Uses SQL statements to retrieve data from Oracle tables and pass it to one or more data-aware components through a TDataSource object. This component provides a mechanism for updating data in Oracle.
	TSmartQuery	A more efficient query component. This component is aware of all the fields that belong to a table being updated and performs on-demand full row retrieval with Expand Fields . A traffic-efficient alternative to TOraQuery for working with large tables with lots of fields. Includes Smart Refresh functionality in Professional and Developer Editions.
	TOraSQL	Executes SQL statements, PL/SQL blocks, and stored procedures, which do not return rowsets.
	TOraTable	Lets you retrieve and update data in a single table without writing SQL statements.
	TOraStoredProc	Executes stored procedures and functions. Lets you edit cursor data returned as parameter.
	TOraNestedTable	Component for controlling nested table data.
	TOraUpdateSQL	Lets you tune update operations for a DataSet component.
	TOraDataSource	Provides an interface for connecting data-aware controls on a form and ODAC dataset components.
	TOraScript	Executes sequences of SQL and PL/SQL statements.
	TOraSQLMonitor	Interface for monitoring dynamic SQL execution in ODAC-based applications.
	TConnectDialog	Allows you to build custom prompts for usernames, passwords, and server names.
	TVirtualTable	Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette.
	TVirtualDataSet	Dataset that processes arbitrary non-tabular data.

ODAC Professional and Developer Edition components

	TOraEncryptor	Represents data encryption and decryption in client application.
	TOraPackage	Provides a straightforward way to access Oracle packages.
	TOraAlerter	Allows you to transfer messages between sessions.
	TOraLoader	Allows you to quickly load data into Oracle databases.
	TOraTransaction	Provides discrete transaction control over sessions. Can be used to manipulate both simple and distributed transactions.
	TOraQueue	Lets you monitor the message queue. Provides an interface for enqueuing and dequeuing messages.
	TOraQueueTable	Component for managing queue tables.
	TOraQueueAdmin	Component for managing queues.
	TOraChangeNotification	Allows you to use Oracle Database Change Notifications.
	TOraTrace	Allows you to start and stop the SQL trace for a specified session. This component provides access to the DBMS_TRACE package.
	TOraErrorHandler	Translates error messages.
	TOraProvider	Loads data to and from a dataset.
	TOraMetaData	Retrieves metadata on specified SQL object.
	TCRBatchMove	Transfers data between all types of TDataSet descendants. This component is placed on the Data Access page of the Component palette.