Loop creation in ODI package
774785Jul 8 2010 — edited Jul 21 2010Hi Expert,
I have declear two variables in pkg.
Var1 --> getting count of records from table (select count(1) from emp)
Var2 --> selected type 'SET VARIABLE' and assign '1' value
Both Variables are NUMERIC DATATYPE
Flow in PKG:
Var1 --> Var2 (select type 'SET VARIABLE' and checked assign and provided '1' value) -->Var1 (select type EVALUATE VARIABLE and choosen operator as '>=' and pass value as '#Var1') --> Var1(selected type 'REFERESH VARIABLE' and writen select query in REFERESHING tab in Var1 variable (select #Var2+1 from dual))
when I run this PKG Iam getting following exception
Exception:
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(BigDecimal.java:368)
at java.math.BigDecimal.<init>(BigDecimal.java:647)
at com.sunopsis.sql.DbFloat.<init>(DbFloat.java)
at com.sunopsis.sql.DbFloat.valueOf(DbFloat.java)
at com.sunopsis.dwg.dbobj.SnpVarSess.compare(SnpVarSess.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.treatTaskTrt(SnpSessTaskSqlV.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.treatTask(SnpSessTaskSqlV.java)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.g.y(g.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Thread.java:595)
Please let me know any one not clear my question
Please any one help me on it
Thanks
Phani
Edited by: Phanikanth on Jul 8, 2010 2:06 AM