Direct Oracle Access 4.1.3.5 For D10.2 Tokyo
DOWNLOAD >>> https://urlca.com/2tuZit
How to Use Direct Oracle Access 4.1.3.5 for D10.2 Tokyo
Direct Oracle Access (DOA) is a component set that allows you to integrate Embarcadero Delphi or C++Builder with Oracle databases. It provides high performance, easy application distribution, Oracle package support, and many other features that make it a great choice for developing Oracle applications.
In this article, we will show you how to use DOA 4.1.3.5 for D10.2 Tokyo, the latest version of DOA that supports Delphi 10.2 Tokyo and C++Builder 10.2 Tokyo. We will cover the following topics:
How to install DOA 4.1.3.5 for D10.2 Tokyo
How to connect to an Oracle database using DOA
How to execute SQL statements and PL/SQL blocks using DOA
How to use Oracle packages and advanced features with DOA
How to Install DOA 4.1.3.5 for D10.2 Tokyo
To install DOA 4.1.3.5 for D10.2 Tokyo, you need to have Delphi 10.2 Tokyo or C++Builder 10.2 Tokyo installed on your computer, as well as Oracle SQL*Net or Net8 client software.
You can download DOA 4.1.3.5 for D10.2 Tokyo from Allround Automations website. You will need to enter your registration details to access the download page.
After downloading the installer, run it and follow the instructions on the screen. The installer will automatically detect your Delphi or C++Builder installation and copy the necessary files to the appropriate folders.
After the installation is complete, you can open Delphi or C++Builder and find the DOA components on the component palette under the \"Oracle\" tab.
How to Connect to an Oracle Database Using DOA
To connect to an Oracle database using DOA, you need to use the TOracleSession component, which represents a database session.
Drop a TOracleSession component on your form or data module and set its properties as follows:
Username: The username of the Oracle user account you want to connect with
Password: The password of the Oracle user account you want to connect with
Database: The name of the Oracle database you want to connect to (this can be a TNS alias or an Easy Connect string)
Connected: Set this property to True to establish the connection or False to close it
You can also use the Connect and Disconnect methods of the TOracleSession component to control the connection programmatically.
How to Execute SQL Statements and PL/SQL Blocks Using DOA
To execute SQL statements and PL/SQL blocks using DOA, you need to use the TOracleQuery component, which represents a query object.
Drop a TOracleQuery component on your form or data module and set its properties as follows:
Session: The TOracleSession component that provides the database connection for this query
SQL: The SQL statement or PL/SQL block you want to execute (you can use parameters and bind variables if needed)
Active: Set this property to True to open the query or False to close it
You can also use the Open and Close methods of the TOracleQuery component to control the query state programmatically.
If your query returns a result set, you can access it using the Fields property of the TOracleQuery component, which returns a collection of TField objects that represent the columns of the result set.
If your query does not return a result set, but performs some action on the database (such as inserting, updating, or deleting records), you can use the ExecSQL method of the TOracleQuery component to execute it without opening it.
How to Use Oracle Packages and Advanced Features with ec8f644aee