INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

WRT_8229 and ORA-26085

WRT_8229 and ORA-26085

(OP)
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

RE: WRT_8229 and ORA-26085

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close