Hi,
i have this problem with saving ODM workflow after editing transform node.
In transform node I made transform edit for variable 'IMP_APPL_PA_EMP_STS_CD_REV_BIN' to bin variable, sql code as is:
case
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('011','040','070','080','090')) then 1
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('012','014','030','051','990')) then 2
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('010','013','050','061','100')) then 3
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('015','020','021','022','023','060')) then 4
when ("IMP_APPL_PA_EMP_STS_CD_REV" is null) then 1
else 3
end
Validation pass well, but after I press save I get mesage:
Unable to save TDW_RISK/Test/binn_test (java.sql.SQLRecoverableException: Closed Connection).
I figure out that when I put shorter sql case-when, example
case
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('011','040','070','080','090')) then 1
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('012','014','030','051','990')) then 2
when ("IMP_APPL_PA_EMP_STS_CD_REV" in ('010','013','050')) then 3
else 3
end
ewerything is ok. When I add one,two or any more 'strings' to case when example:061','100' same error happend again.
I try to do that with differen datasource in different workfolows but nothing helped.
I found workaround using SQLNode and it work but it is not best, since we have to use transform for other variables.
Any Idea why is this happenning? Any known restrictions in SQL Developer Transform node?
System: SQL Developer Version 4.0.0.12, Database 11.2.0.2
Regards,
Kreso