Data Access Techniques

These techniques provide code examples for enabling your applications to access the relational databases and other data sources they require. They are organized into the following categories:

• Data source objects

• Oracle access

• General

Data source objects   

These techniques include:

• Using an executeSQL DSO

• Using a setResultSet DSO

• Using a setDataSource DSO

• Importing a Comma-Delimited File into a Database Table

• Exporting a Database Table to a Formatted File

• Publishing Data Between Databases

• Developing a DSO for Use by Multiple Clients

Oracle access   

These techniques include:

• Accessing Blobs in Oracle

• Accessing Clobs in Oracle

• Calling an Oracle PLSQL Function Returning a Cursor

General   

These techniques include:

• Handling Data Concurrency Errors

• Dynamically Binding Controls to Data