4 Replies Latest reply: Oct 26, 2013 8:31 AM by Srini VEERAVALLI RSS

    Informatica Error WRT_8829

    57f304c5-15d8-47a2-9b1b-63a4f544b11a

      Happy Friday Oracle experts,

       

      My Friday has started with the following error when trying to run a test mapping (for practice purposes). I would appreciate any suggestions :

       

       

      SeverityTimestampNodeThread
      ERROR10/25/2013 10:28:23 AMnode01WRITER_1_*_1WRT_8229

       

       

      Message

      -----------------------------------------------------------------------------------------------

      Database errors occurred:

      ORA-00604: error occurred at recursive SQL level 1

      ORA-00942: table or view does not exist

       

       

      Database driver error...

      Function Name : Prepare DPL

      SQL Stmt : INSERT INTO EMP_TARGET2(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

      Oracle Fatal Error

      Database driver error...

      Function Name : Execute Multiple

      SQL Stmt : INSERT INTO EMP_TARGET2(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

      Oracle Fatal Error

      ---------------------------------------------------------------------------------------------------

       

      I'm working on importing SQL - Select * from employees where Department_ID =50  from EMPLOYEES table in the HR Schema to a shell copy of EMPLOYEES that I created by copying the EMPLOYEES table.

       

      Thanks for your time in advance

      Giorgio