Workflow [message #215500] |
Mon, 22 January 2007 10:49 |
lowcash75
Messages: 67 Registered: February 2006
|
Member |
|
|
Does anyone have any good ideas/suggestion on how to go about building a workflow data model? State tables and so on? We're not planning on using any workflow applications but instead build our own workflow, as the flows aren't too complex.
Please provide any info if anyone has any experience building a workflow database.
Thanks!
|
|
|
|
Re: Workflow [message #215511 is a reply to message #215500] |
Mon, 22 January 2007 11:23 |
lowcash75
Messages: 67 Registered: February 2006
|
Member |
|
|
Customer doesn't want to use any additional tools/applications. They are afraid of maintenance. They want to build their own. Plus the processes are very simple and sequential.
|
|
|
|
Re: Workflow [message #215724 is a reply to message #215546] |
Tue, 23 January 2007 12:03 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
See
http://forums.oracle.com/forums/forum.jspa?forumID=72
http://www.workflowfaq.com/
To avoid using the Oracle workflow tables, you can keep your own table in another schema (seperate or as part of the application schema). You can pass control between workflow and the application using Raise, ResumeProcess (and I think Rerun which can be used to force a workflow to run from a particaular position - this is useful becuase you want to control the workflow state from your own app).
I think there's an example of using "raise event" and passing control to an external app - see the docs. Raise event isn't necessary - but desirable in my view.
[Updated on: Tue, 23 January 2007 12:04] Report message to a moderator
|
|
|