My Oracle Support Banner

ADB : Is It Supported To Use Builtin Functions "timestamp_to_scn" And "scn_to_timestamp" in Autonomous Databases (Doc ID 2677000.1)

Last updated on JUNE 15, 2020

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A and later
Information in this document applies to any platform.

Goal

Applications using builtin functions "timestamp_to_scn" and "scn_to_timestamp" in Autonomous databases report "ORA-00904: "SCN_TO_TIMESTAMP": invalid identifier" error. This document clarifies support for these functions in ADB environment.
 

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.