5 Replies Latest reply on Feb 26, 2016 2:30 PM by 3173245

    issue with Odi Variable

    3173245

      Hi all

      I'm trying to use variables for transferring data from multiple files to single table as directed from below link.

      ODI Gurus: MULTIPLE FILES - SINGLE TARGET TABLE-SINGLE INTERFACE

       

      When im trying to execute that package im getting an error at second step that is at variable FILE_NAME and my refresh code is

       

      select file_name from (select file_name, rownum rn from file_loop_variable) where rn=#Test_Project.count

       

      ODI-1228: Task FILE_NAME (Variable) fails on the target  connection Orcl_pa_emp_target_table.

      Caused By: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

       

       

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)