Query Examples

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.