1 Reply Latest reply: Dec 7, 2012 12:05 AM by Sutirtha Roy RSS

    ODI procedure error

    797774
      Hi,

      I m getting error while running following query in procedure.Please help me to overcome the problem.

      SELECT TRIM (FTP_TARGET_LOC) ftp_tgt_loc,
      TRIM (FTP_SERVER) ftp_server_ip,
      TRIM (FTP_USERID) ftp_userid,
      TRIM (FTP_PASSWORD) ftp_passwd,
      TRIM (FTP_SOURCE_DIRECTORY) ftp_src_dir,
      TRIM (FTP_TARGET_DIRECTORY) ftp_tgt_dir,
      TRIM (src_file_nm) src_file_nm,
      TRIM (FTP_TYPE) ftp_type,
      TRIM (FTP_DATA_FILE_NM) trgt_file_nm,
      '#GLOBAL.g_FTP_FILE_DEL_IND' del_ind,
      zip_ind zip_ind,
      TRIM (UNIQUE_ARCH_ID_IND) arch_ind,
      TRIM (ARCHIVE_DIRECTORY) arch_dir,
      '#GLOBAL.g_ADM_ETL_XML_FILE_NM' del_fil
      FROM ODIADM.FTP_PARAMETER
      WHERE FTP_TARGET_LOC = '#GLOBAL.g_FTP_TGT_LOC'


      Error message:

      923 : 42000 : java.sql.SQLException: ORA-00923: FROM keyword not found where expected

      java.sql.SQLException: ORA-00923: FROM keyword not found where expected

           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
           at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
           at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
           at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrdersOSOder(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(SnpSessTaskSqlS.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
           at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
           at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
           at com.sunopsis.dwg.cmd.e.k(e.java)
           at com.sunopsis.dwg.cmd.g.G(g.java)
           at com.sunopsis.dwg.dbobj.SnpScen.a(SnpScen.java)
           at com.sunopsis.dwg.dbobj.SnpScen.localExecuteSync(SnpScen.java)
           at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java)
           at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(SnpSessTaskSqlS.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
           at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
           at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
           at com.sunopsis.dwg.cmd.e.k(e.java)
           at com.sunopsis.dwg.cmd.h.A(h.java)
           at com.sunopsis.dwg.cmd.e.run(e.java)
           at java.lang.Thread.run(Thread.java:595)
        • 1. Re: ODI procedure error
          Sutirtha Roy
          794771 wrote:
          Hi,

          I m getting error while running following query in procedure.Please help me to overcome the problem.

          SELECT TRIM (FTP_TARGET_LOC) ftp_tgt_loc,
          TRIM (FTP_SERVER) ftp_server_ip,
          TRIM (FTP_USERID) ftp_userid,
          TRIM (FTP_PASSWORD) ftp_passwd,
          TRIM (FTP_SOURCE_DIRECTORY) ftp_src_dir,
          TRIM (FTP_TARGET_DIRECTORY) ftp_tgt_dir,
          TRIM (src_file_nm) src_file_nm,
          TRIM (FTP_TYPE) ftp_type,
          TRIM (FTP_DATA_FILE_NM) trgt_file_nm,
          '#GLOBAL.g_FTP_FILE_DEL_IND' del_ind,
          zip_ind zip_ind,
          TRIM (UNIQUE_ARCH_ID_IND) arch_ind,
          TRIM (ARCHIVE_DIRECTORY) arch_dir,
          '#GLOBAL.g_ADM_ETL_XML_FILE_NM' del_fil
          FROM ODIADM.FTP_PARAMETER
          WHERE FTP_TARGET_LOC = '#GLOBAL.g_FTP_TGT_LOC'


          Error message:

          923 : 42000 : java.sql.SQLException: ORA-00923: FROM keyword not found where expected

          java.sql.SQLException: ORA-00923: FROM keyword not found where expected
          Make sure all of your Global variable is getting proper value before those are used inside your procedure