Oracle 18c Adapter Limitations

Supported Types

The types supported in this adapter are the following.

Type name	Support	Remarks
CHAR	Limited
NCHAR	Limited
VARCHAR2	Yes
NVARCHAR2	Limited
LONG	Yes
NUMBER	Limited
FLOAT	Limited
DATE	Limited
TIMESTAMP	Limited
TIMESTAMP WITH TIME ZONE	Limited	Data is handled as String.
TIMESTAMP WITH LOCAL TIME ZONE	Limited	Data is handled as String.
RAW	Yes
LONG RAW	Yes
BLOB	Yes
CLOB	Yes
NCLOB	Yes

Displaying table list
- Tables that belong to the schema of the user specified in [User name] in the global resource are displayed.
- Synonym is not displayed.

NUMBER, FLOAT
- When the Precision of a query result is 0, the data is handled as BigDecimal. For example, even if Precision is set to the column specified in SUM function, 0 will be returned as a result, so the result of SUM function will be handled as BigDecimal.
SQL statement with functions
- SQL statement with SQL functions can be executed.
- Though the SQL statement with user-defined functions can be executed, the value of OUT parameter defined in the functions cannot be received.
Default value of [Fetch size] is 100.

CHAR
- When updating, if the column in which you checked [Schema definition/Key] is CHAR type, the key value of the input data has to be padded in the same size.
When the table name is enclosed with quotation marks, it is case-sensitive.

CHAR
- When a CHAR type column is specified in the WHERE clause of an UPDATE statement, and getting the value of the column with SQL parameter, the key value of the input data has to be padded in the same size.
SQL statement with functions
- SQL statement with SQL functions can be executed.
- Though the SQL statement with user-defined functions can be executed, the value of OUT parameter defined in the functions cannot be received.

CHAR
- Unnecessary spaces might be added to an OUT parameter of CHAR type.
Procedure description
- Procedures defined in a package are described as [package name].[procedure name].
- When a package name includes dot (.), enclose the name with double quotations (").
  Example: In the case of “PROCEDURE” procedure that is defined in “SAMPLE.PACKAGE” package
  - "SAMPLE.PACKAGE".PROCEDURE
- When a procedure name includes dot (.), enclose the name with double quotations (").
  Example: In the case of “SAMPLE.PROCEDURE” procedure that is defined in “PACKAGE” package.
  - PACKAGE."SAMPLE.PROCEDURE"
When a stored function is specified in [Procedure], there are cases in which the return value of RETURN statement cannot be retrieved as output parameter, and the operation fails with the following error during script execution.
- [exec_procedure] failed. Cause: [java.sql.SQLException: ORA-06550: '<procedure name>' is not a procedure or is undefined.]
PL/SQL types such as BOOLEAN are not supported.

A procedure of a schema that is different from the schema of the user specified in [User name] in the global resource cannot be used.

NCHAR, NVARCHAR2
- Column length is handled as byte length, not string length.
  However, when the character set of Oracle Database Client is UTF-16, it is handled as string length.
DATE
- It has to be formatted in the standard format of Oracle as [YYYY-MM-DD] beforehand.
TIMESTAMP
- It has to be formatted in the standard format of Oracle as [YYYY-MM-DD Hh24:MI:SS] beforehand.
When the table name is enclosed with quotation marks, it is case-sensitive.

Exception name		Cause	Solution
java.sql.SQLException	ORA-01017: invalid username/password; logon denied	The user name or the password is incorrect.	Check [User name] or [Password] of the global resource.
java.sql.SQLException	Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor	The SID is invalid.	Check [SID] or [URL] of the global resource.
java.sql.SQLRecoverableException	IO Error: The Network Adapter could not establish the connection	Unable to connect to the database.	Check [Host name] or [Port number] of the global resource.
java.sql.SQLSyntaxErrorException	ORA-00942: The table or the view does not exist.	Either the table or the view does not exist or the table or view name might not be enclosed with quotation marks.	Specify the table or the view that exists in [Table name]. Also check whether the table or view name specified in [Table name] is enclosed with quotation marks.
oracle.jdbc.xa.OracleXAException		Multiple XA global resources might be used, which refers to the same database, in a script of which transaction is enabled.	When referring to the same database in multiple processes with Oracle XA connection, use the same global resource.