This content has been marked as final. Show 4 replies
923 : 42000 : java.sql.SQLException: ORA-00923: FROM keyword not found where expected
Select Exception getPrevStepLog("INSERT_COUNT") : No previous Step as rec from dual
but in the previous step 1k records are insetred
Query used in the procedure(Source) is
Select <%=odiRef.getPrevStepLog("INSERT_COUNT")%> as rec from dual
the same query works when the procedure is used instead of the generated scenario(procedure)
There is maybe a problem with your ODI getPrevStepLog Substitution Method :
On metalink, read this DocId : 744117.1
Note : This Subtition does not exists on Sunopsis V3-V4.
Part of DocId :
1. First create an Integration Interface that loads data from source to target.
2. Create a Specific Procedure, for example "AUDIT_COUNT" and insert a command "INSERT_UPDATE_COUNT" and include the following usig the expression editor:
INSERT INTO AUDIT_DT
3. Create an ODI Package, for example "LOAD_PKG", and include the Integration Interface followed by a call to the Specific Procedure as shown below:
Edited by: user967629 on 31 août 2009 04:54
that is a "Session" problem.
Once each scenario is a new ODI session, the internal API getPrevStepLog is re-initialized when a new scenario starts.
To get the values, you need to "ask" in the same session then a scenario can't be used. You must use the procedure instead scenario in this case.
Make any sense?