Oracle Workflow usable for big transactions (commit issue)?

I have an application that I want to model in the workflow builder as the user interface and functionality is quite what I need. However, it is not a buisness process kind of thing, rather a huge datawarehouse and I d like to model the import and transformations.

I know that it is not allowed to do commits within workflow processes, but I would need to do some cause of my transactions being rather big and long. If I am not doing commits, I am using up ridiculous amounts of rollback segment space and running into trouble.

Question is, is Oracle workflow the right thing to handle these huge transactions??
What can I do about it or which other software would you recommend?

I know, that I can do autonomous transactions, but I am not feeling like wrapping all the functionality again. Received on Wed Mar 26 2003 - 09:05:40 CST