Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a scenario where I need to run a set of jobs depending on a output of a sql, so i'm using twaitforsqldata. the SQL has to be executed only once, only if it returns a row, the flow should proceed otherwise it has to skip all jobs. when i use the below sql in twaitforsqldata, i'm getting the error "java.sql.SQLException: Result set after last row", when i searched it seems like java produces this error when the sql returns no rows. Even when there is a option to check for Zero rows in twaitforsqldata, why am I getting this error? and is there any way to handle this in twaitforsqldata ( at this moment i don't want to use a java component)
SELECT '1' col FROM table1 WHERE (select somefunction('dfd') from dual) = 'YES'
thanks
mj