PL/SQL (MOSC)

MOSC Banner

SYSTIMESTAMP as "invalid timestamp"

edited Apr 15, 2014 12:00PM in PL/SQL (MOSC) 3 commentsAnswered


Hi!

I have a valid Oracle select:

SELECT * from FROM test_table AS OF TIMESTAMP (SYSTIMESTAMP);

(This is a minimalized "debug" version of original, problematic query, from a stored procedure.)

Above select work most of Oracle RDBMS versions (10.2.0.4, 11.2.0.2, 12.1.0.1).

But only one Oracle 11.2.0.4 I get the "ORA-08186 invalid timestamp specified"  error.
The Oracle 11gr2 standard database installed on Windows Server 2012 R2. (Timezone

GMT+1 with "daylight saving". Query run on the server.)

Why ?

I found, that nls and flashback settings the "good" and "bad" database are equal.
Results of "select SYSTIMESTAMP from dual;" are equal also.


Help. What can i check ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center