Oracle 10gR2 Adapter Limitations

• Supported Types
• Read Table Limitations
• Execute Select SQL Limitations
• Write Table Limitations
• Execute Update SQL Limitations
• Execute Stored Procedure Limitations
• Write by Loader Limitations
• Specification Limits
• Main exception messages

Supported Types

• Yes: Support.
• Limited: Support with limitations.
• No: Not support

Read Table Limitations

• If the table name is enclosed by quotation marks, the table names are case-sensitive.


• Synonyms are not supported.

Execute Select SQL Limitations

• NUMBER, FLOAT type, DOUBLE PRECISION type, REAL type, NUMERIC
  • When the Precision of query result is 0, handle data as BigDecimal. For example, Precision is set in column specified with SUM function and the result is returned as 0, so the result of the SUM function is handled as BigDecimal.
  
  
• SQL statements using the function
• SQL statements using SQL functions can be executed.


• SQL statements using user-defined functions can be executed, but the value of OUT parameters defined by function cannot be received.


• Synonyms are not supported.

Write Table Limitations

• If the table name is enclosed by quotation marks, the table names are case-sensitive.


• Synonyms are not supported.

Execute Update SQL Limitations

• SQL statements using the function
• SQL statements using SQL functions can be executed.


• SQL statements using user-defined functions can be executed, but the value of OUT parameters defined by function cannot be received.


• Synonyms are not supported.


• When Oracle OCI connection settings with [XA connection] checked is specified in [Destination], the following error may occur and lead to processing failure when executing DDL.
  
  • [Exec_update] process failed.Cause: [java.sql.SQLException: ORA-02089: COMMIT is not available in the lower session. ]

Execute Stored Procedure Limitations

• CHAR
  • OUT parameter of type CHAR, additional spaces may be added.


• Procedure Notation
  • Procedure defined in the package is described Procedures are defined in the package [package]. [Procedure name].
  • When dot (.) is contained in the procedure name, enclose it with double quotation marks (").
    For example: "SAMPLE.PROCEDURE" defined in package "PACKAGE"
    • PACKAGE. "SAMPLE.PROCEDURE"


• Procedure cannot be executed in packages which contain dot (.) in the name.


• Return value of RETURN clause can not be retrieved.


• Synonyms are not supported.

Write by Loader Limitations

• DATE
  • Need to be pre-formatted to Oracle standard format [YYYY-MM-DD].


• TIMESTAMP
  • Need to be pre-formatted to Oracle standard format [YYYY-MM-DD Hh24:MI:SS].


• If the table name is enclosed by quotation marks, the table names are case-sensitive.


• Synonyms are not supported.

About Client Tools

• Oracle client is required in the host where DataSpiderServer is installed.

Supported Client Version

• 10.2 (Windows)

Specification Limits

• At table list (e.g. [Table name]), The table that belongs to the schema of the user specified for the [User name] of Global Resource is displayed.

Main exception messages