rDear Experts.
I have one package and have a last step as one variable which one is refresh variable and wrote one query as below:
SELECT INSERT_COUNT from STAT_TABLE where SESS_NO = '<%odiRef.getSession("SESS_NO")%>' -- this variable i am using in email body to include the session insert and update count
Here STAT_TABLE one of our meta data table which populated with session statics like sess no,insertcount,updatecount and error count
This variable is failing with error:
ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection
Caused By: java.sql.SQLException: SQL string is not Query
Whery i try below with including quotes, then I get different error
SELECT INSERT_COUNT from STAT_TABLE where SESS_NO = <%odiRef.getSession("SESS_NO")%>
ora 1228 :Missing expression
Is there any syntax mistake... SESS_NO in that STAT_table is NUMBER type.
What I all need is to bring actual insert that has happened, actual update for particular session.
I tried previous step log , but it not correct as it is evaluating only previous step not entire session, However, i have placed varaible with previousstep log after intertaface step, but still result is same, its not capturing actual count of inser or update that has happend on target table.
Please help
Regards
ASP