Home How To Online Documentation Support Download Order

 

 

Connecting to databases
Transactions
Executing an SQL command
Executing stored procedures
Binding input parameters
Fetching result set
Fetching multiple result sets
Optimizing Database Performance
Returning output parameters
Working with Long or Lob(CLob, BLob) Data
Working with date/time values
Error handling
Using native API
Query examples


Query Examples

Steps

Step 1. Connecting to database (and error handling)
This step shows how to connect to/disconnect from databases using the Library. It also shows how to handle errors.
Step 2. Executing a simple SQL command
This step show the example of executing a simple query without any parameters and result set.
Step 3. Binding input parameters
This step shows 2 methods for providing input parameters in SQLAPI++: direct assignment and stream-based.
Step 4. Executing a select query (and fetching result set)
This step shows how to process result set using SQLAPI++.
Step 5. Binding LongBinary, LongChar, BLob and CLob data
This step shows 2 methods for binding Long or Lob data: traditional (bind all the data in one piece) and piecewise (using user defined callbacks for providing data).
Step 6. Fetching LongBinary, LongChar, BLob and CLob data
This step shows 2 methods for fetching Long or Lob data: traditional (read all the data in one piece) and piecewise (using user defined callbacks for reading data).
Step 7. Multithreading support and cancelling queries
This step shows how to create a thread with long running query.

Advanced examples

Using Oracle REF CURSORs. This example demonstrates how to get Oracle REF CURSORs from a stored procedure and than fetch it using SQLAPI++ Library.
Using Oracle nested cursors. This example shows how SQLAPI++ handles queries with nested cursors.

Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.