ORA-00911 When Using 11.2.x JDBC Timestamp Literal 'ts'
(Doc ID 1434015.1)
Last updated on JUNE 05, 2023
Applies to:
JDBC - Version 11.2.0.1.0 to 11.2.0.3.0 [Release 11.2]Information in this document applies to any platform.
Symptoms
Using JDBC 11.2.0.1, when executing two JDBC timestamp literal 'ts' in a single query without a space between the ts literal and value, ORA-00911: invalid character error occurs.
The error does not occur when a single timestamp literal is used in the SQL query.
While executing JDBC timestamp literal 'ts' and date literal 'd' also, the ORA-00911 error is encountered.
Example :
Error :
ORA-00911: invalid character
ORA-00936: missing expression
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |