WRT_8229 and ORA-26085

[JDAEMS]

Hi,

When running a simple workflow with two tasks and one session, the session fails and it gives the following error message:

-----------------------
WRT_8229 Database errors occurred:
ORA-26085: direct path operation must start its own transaction

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO DWH_D_REASON_CODE(REA_CODE,REA_CMP_CD,REA_D_SK,ETL_JOB_KEY_INSERT,ETL_INSERT_BY,ETL_INSERT_ON,REA_D_CMP_D_SK,REA_DESC) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO DWH_D_REASON_CODE(REA_CODE,REA_CMP_CD,REA_D_SK,ETL_JOB_KEY_INSERT,ETL_INSERT_BY,ETL_INSERT_ON,REA_D_CMP_D_SK,REA_DESC) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
-----------------------

I totally don't have a clue where to go looking for the problem? Can anyone help me out?

Thanks in advance
Jelle

 

[rhitesh02]

Hi,

I am not sure but do check in load type if you have load type as "BULK" than change it to "Normal" and try to execute.

Hope this helps!

-Hitesh Rathod