Re: Quick Oracle Connection ...

["Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>]

On 15/01/2018 13:22, tonikaparallele@gmail.com wrote:

> Thank you so much, Dimitry! In addition to my other activities, it 
> seems too time-consuming to understand everything to do some simple 
> database queries.

You mean SQL, or how to create connection, prepare statement, bind 
arguments, walk the result set?

> Is there any example programs?Unfortunately I have little experience
> with communication ada-oracle.

It is no different from how ODBC is used in other programming languages, 
a bit simpler because the environment, connection and statement objects 
are controlled, so there is less to care about releasing handles.

There is a test program that calls all API operations, there are many 
Ada application programs that use ODBC. And you can easily translate C 
ODBC sample code.

It quite straightforward:

1. Declare ODBC_Environment
2. Declare ODBC_Connection
3. Connect to the RDBMS

4. Declare ODBC_Command
5. Prepare (set a SQL statement)

6. Bind parameters, if any
7. Execute the command

8. Fetch the result set

9. Get_Data for a column of the fetched row in the result set, if any

    repeat 9 if many columns
    repeat 8 if many rows
    repeat 6 to execute same statement anew
    repeat 5 to execute another statement

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de