Says it cannot find a valid statement when using an equation to get date value (4244551)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Says it cannot find a valid statement when using an equation to get date value
Description

When using an equation to get a date in a SQL, like the one below, the optimzer returns a message saying, "The Parser did not identify the text as a valid SQL statement".

SELECT *
FROM DUAL
WHERE 'N' = CBC_GETSHIFT(SYSDATE -(:P10_HOURSDIFF1 / 24), 'N')
Cause

Appears to be an Oracle bug. Oracle cannot generate an explain plan.
Resolution

To work around this, convertthe firest parameter to DATE data type. For example:

SELECT *
FROM DUAL
WHERE 'N' = CBC_GETSHIFT(to_date(SYSDATE -(:P10_HOURSDIFF1 / 24)), 'N')

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title