My Oracle Support Banner

INSERT Statement With Using SYSDATE To VALUES Failed On Run SQL Statement In DBaaS Adapter (Doc ID 3006605.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Integration 3 - Version N/A and later
Information in this document applies to any platform.

Goal

INSERT statement like the below success, but another one fails.

Success


Is this difference in behavior due to some setting?
Is it a specification?

ex.DDL
CREATE TABLE TEST_TBL (
CREATED_BY VARCHAR2(10)
, CREATION_DATE DATE
);

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.