SQL unexpected token error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

SQL unexpected token error

I have the below section as part of a long query that keep spitting out the error code:

Encountered unexpected token: "(" "("
    at line 188, column 13.

Was expecting one of:

    "&"
    ")"
    "::"
    "<<"
    ">>"
    "["
    "^"
    "|"

code:

AND (trunc(to_date(peef.effective_start_date, 'yyyy-MM-dd'T'HH:mm:ss.SSSZ')) between TRUNC(:eff_mon, 'MM') and TRUNC(ADD_MONTHS(SYSDATE, 1), 'MM') -1)
AND (trunc(to_date(peef.last_update_date),'yyyy-MM-dd'T'HH:mm:ss.SSSZ') < TRUNC(:eff_mon, 'MM'))

I have tried moving a few things around but nothing is solving the issue.

TYIA!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!