2 Replies Latest reply: Jan 8, 2013 6:56 AM by aetl RSS

    ODI 10g Call sqlldr SID

    aetl
      Hi everyone,

      I am using LKM File to Oracle(SQLLDR) .My call sqlldr step like this:

      OdiOSCommand "-OUT_FILE=<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].out", "")%>" "-ERR_FILE=<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].err", "")%>"
      sqlldr "control='<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].ctl","")%>'" "log='<%=odiRef.getSrcTablesList("[WORK_SCHEMA]/[TABLE_NAME].log", "")%>'"
      userid=<%=odiRef.getInfo("DEST_USER_NAME")%>/<%=odiRef.getInfo("DEST_PASS")%>@<%=odiRef.getInfo("DEST_DSERV_NAME")%>

      Bu My problem is here.it returned OS system return 1:it can not get DEST_DSERV_NAME .I have SID name therefore I I must get SID name

      When I change manually DEST_DSERV_NAME to @DVLODS(this is my SID name) it works fine.How can I do that dynamicly?When I run interface call sqllldr is seen like this:

      OdiOSCommand "-OUT_FILE=C:\Users\xx\Desktop\ODI1/ALL_FILE.out" "-ERR_FILE=C:\Users\xxx\Desktop\ODI1/ALL_FILE.err"
      sqlldr "control='C:\Users\xx\Desktop\ODI1/ALL_FILE.ctl'" "log='C:\Users\xx\Desktop\ODI1/ALL_FILE.log'" userid=SYSTEM/<@=snpRef.getInfo("DEST_PASS") @>@

      Can anyone help me?

      Thanks.