PL/SQL (MOSC)

MOSC Banner

ORA-01861: literal does not match format string

in PL/SQL (MOSC) 5 commentsAnswered

Hello,

I have a query made in oracle 18C on a sql server base made via dblink and it works as expected.

I'm performing a migration to 19C and I get the following error:

ORA-01861: literal does not match format string

01861. 00000 - "literal does not match format string"

*Cause: Literals in the input must be the same length as literals in

the format string (with the exception of leading whitespace). If the

"FX" modifier has been toggled on, the literal must match exactly,

with in the extra whitespace.

*Action: Correct the format string to match the literal.



Where the field that emits an error is the DataPayment of type datetime2 within the sql server.

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