Database Adapter Limitations
Limitations Common to Database Adapters
- Materialized view cannot be used.
- In Execute Stored Procedure operation, it is not possible to execute a stored procedure overloaded with the same name.
Each Database Adapter Limitations
-
When reading and writing to the same table, perform that with the same global resource.
When other global resources are used, it may not be possible to read the written data.
- Even when the same global resource is used, if transactions are different, it may not be possible to read the written data.
-
Although link tables are not displayed in the table list, you can read / write by directly specifying the table name.
-
In Write Table, Read Table, and Execute Select SQL operation, an error might occur when reading / writing to a table with symbols in its name.
Each adapter limitations
Each adapter limitations
Sales and support for the following adapters are finished.
Each adapter limitations
Sales and support for the following adapters are finished.
- In Execute Update SQL operation, PL/SQL cannot be executed.
- In Execute Stored Procedure operation, the time information of DATE type data cannot be written / read.
- When a connection settings of which [Type] is XA Oracle is specified in [Destination], DDL statement, DML statement with commit declared, or stored procedure cannot be executed. When executing, “ORA-02089” error occurs.
Each adapter limitations
Sales and support for the following adapters are finished.
Each adapter limitations
Sales and support for the following adapters are finished.
- Link server function is not supported.
- In Write Table operation, you cannot write to a table which has a column with a name including a quotation.
Each adapter limitations
Sales and support for the following adapters are finished.
Sales and support for the following adapters are finished.
Sales and support for the following adapters are finished.