DSQL API Limitations

Go Up to Working with Dynamic SQL

Although DSQL offers many advantages, it also has the following limitations:

• Dynamic transaction processing is not permitted; all named transactions must be declared at compile time.
• Dynamic access to Blob and array data is not supported; Blob and array data can be accessed, but only through standard, statically processed SQL statements, or through low-level API calls.
• Database creation is restricted to CREATE DATABASE statements executed within the context of EXECUTE IMMEDIATE.

See Also

• Accessing Databases
• Handling Transactions
• Processing Blob Data
• Processing Array Data
• DSQL API Limitations for Database Creation

Advance To:

• Accessing Databases