After mapping tables and develops interfaces in ODI, I have developed the packages.
In the packages, I am intending to develop procedures for logging in a freehand in the destination scheme.
I then found the GetPrevSteplog method, which would suit me in every way.
occurs that using some parameters of this method, error is issued in the procedure "ORA-00936: Missing Expression", the funny thing that with some works.
INSERT INTO <%=odiRef.getSchemaName()%>.RESUMO_ODI_CARGAS (
ID_CARGA,
PACOTE,
DT_CARGA_INI,
DT_CARGA_FIM,
STATUS,
SESSAO_ORACLE,
QTD_REGISTROS,
ERRO,
DURACAO)
SELECT
<%=odiRef.getSchemaName()%>.SEQ_RESUMO_ODI_CARGAS.NEXTVAL,
'01 - CARREGA CLIENTE',
<%=odiRef.getPrevStepLog("BEGIN")%>,
<%=odiRef.getPrevStepLog("END")%>,
DECODE(<%=odiRef.getPrevStepLog("STATUS")%>, 'D', 'SUCESSO',
'E', 'INSUCESSO',
'DESCONHECIDO'),
#GET_SESSION_ODI,
<%=odiRef.getPrevStepLog("INSERT_COUNT")%>,
<%=odiRef.getPrevStepLog("MESSAGE")%>,
<%=odiRef.getPrevStepLog("DURATION")%>
FROM DUAL
Does anyone have any idea what it is?
Hugs.