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 :
| Severity | Timestamp | Node | Thread | | |
|---|
| ERROR | 10/25/2013 10:28:23 AM | node01 | WRITER_1_*_1 | WRT_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