Encountered the symbol ">" when expecting one of the following ( * @ % & = - + < / >

Help Studio
,
1

I am executing the below sql statement and facing this error

"SELECT     t.i_id,
       to_char(t.open_time +4/24,'dd-mon-yy hh24:mi') open_time,
       t.opened_by,
       to_char(t.close_time+4/24,'dd-mon-yy hh24:mi') close_time,
       t.title,
       dbms_lob.substr(t.description,1000) description
FROM       INCIDENTSM1 t
where      t.OPEN_TIME >= to_date(@startt) AND t.OPEN_TIME < to_date(@endd) AND t.INCIDENT_ID IN (SELECT DISTINCT a1.INCIDENT_ID  FROM   INCIDENTSA1 a1 ) ;"

and passing startt and endd as parameters

oracle error

Encountered the symbol “>” when expecting one of the following ( * @ % & = - + < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec as between || multiset member submultiset The symbol "( was inserted before “>” to continue.

any one have an idea

2

hi @FMK,

Have you tried Running this Query in the Query Editor of DB Directly , Does it Work there ?

–
Mukesh

1 Like
3

yes it works in the query editor

4

It seems that the connection to the oracle database was wrong
I followed these steps then added the connection in uipath

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.