ORA-01555 From Flashback Query If Using AS OF TIMESTAMP Clause with TO_DATE or TO_TIMESTAMP Function Calls Having BIND Input Argument (Doc ID 3072404.1)

Last updated on FEBRUARY 18, 2025

Applies to:

Symptoms

A flashback query that uses the AS OF TIMESTAMP clause with the TO_DATE or TO_TIMESTAMP function calls that have a bind input value will fail with error ORA-1555.

Example 1:

Changes

The error was noticed after changing parameter CURSOR_SHARING to FORCE because this results in the literals being changed into system generated bind values.   The triggering condition is the query passed to the optimizer uses the AS OF TIMESTAMP clauses and has a TO_DATE or TO_TIMESTAMP function call that uses a bind variable as a input argument.

Cause

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