ODAC allows Oracle access for Borland Delphi and C++ Builder without requiring the use of BDE.
One of the key advantages of ODAC is that it offers a Net option, which allows it to work directly through TCP/IP and eliminates the need for Oracle software on the client side. This is a major advantage that makes ODAC a very attractive option for developers who want to save on installation and administration costs.
Some of the other benefits of using ODAC include its support for Oracle 8 features, such as BLOB, CLOB, and BFile data types, objects, arrays, references, and nested tables. Additionally, it simplifies data updating and allows for both flexible updating with TOraQuery and easy updating with TSmartQuery.
ODAC speeds up the process of fetching records from the database, provides automatic locking and refreshing of records, and allows developers to execute long-time stored procedures in a separated thread. It also features advanced design-time editors and an interface (methods, properties) that is similar to standard data access components (TDatabase, TQuery, etc.).
Another advantage of ODAC is that it supports all data-aware components. Users can take advantage of the software's Net option, which allows your application to work with Oracle directly through TCP/IP protocol and eliminates the need for Oracle client software. To connect to the Oracle server with ODAC Net, users need to know the address of the computer where Oracle server is, the listening port number, and the database instance name.
Version 4: N/A