Hi Mike,
Here is the error I am getting on this one.
select A.ACTIVITYNAME, A.DATACENTER, A.CYCLEDAY, A.RUNMONTH || A.RUNYEAR AS CYCLE, floor(((ACTUALACTIVITYBEGIN - TARGETACTIVITYBEGIN) * 24 * 60 * 60)/3600) as Start_Var_Hours, floor(((ACTUALACTIVITYEND - TARGETACTIVITYEND) * 24 * 60 * 60)/3600) as End_Var_Hours from TBLTWCYCLERUN A, TBLTWCYCLEDETAIL B where A.DATACENTER = B.DATACENTER and A.RUNYEAR = B.RUNYEAR and A.RUNMONTH = B.RUNMONTH and A.CYCLEDAY = B.CYCLEDAY and DATACENTER in ('M01') and ACTIVITYNAME in ('Bill Day Process') and A.CYLCEDAY in ([Ljava.lang.Object;
@5778a8) and RUNMONTH between (08 and 11) and RUNYEAR between (2008 and 2008) group by DATACENTER,CYCLEDAY,ACTIVITYNAME order by DATACENTER,CYCLEDAY,ACTIVITYNAME
Table (id = 249):
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00936: missing expression
CYCLEDAY in (What?)
Thanks
Nurani Sivakumar
