This discussion is archived
4 Replies Latest reply: Oct 26, 2013 6:31 AM by Srini VEERAVALLI RSS

Informatica Error WRT_8829

57f304c5-15d8-47a2-9b1b-63a4f544b11a Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points