I believe that a solution is like this one:
UPDATE OFBIZ.JOB_SANDBOX
SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ?
WHERE (
(
RUN_TIME <= to_date('2010-10-04 13:15:55.897') AND
START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND
RUN_BY_INSTANCE_ID IS NULL
)
AND
(
POOL_ID IS NULL OR
POOL_ID = 'pool'
)
)
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/ORA-01830-installing-OFBiz-with-Oracle-10g-tp2955805p2955806.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
