Home » Other » General » Workflow
Workflow [message #215500] Mon, 22 January 2007 10:49 Go to next message
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 #215505 is a reply to message #215500] Mon, 22 January 2007 11:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you checked out Oracle Workflow Developer's Guide? You don't have to buy a Workflow solution. If you have the database, then you already have a Workflow solution.
Re: Workflow [message #215511 is a reply to message #215500] Mon, 22 January 2007 11:23 Go to previous messageGo to next message
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 #215546 is a reply to message #215511] Mon, 22 January 2007 18:11 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
lowcash75 wrote on Tue, 23 January 2007 04:23
They are afraid of maintenance.

/forum/fa/449/0/ Sounds more like they love maintenance.
Re: Workflow [message #215724 is a reply to message #215546] Tue, 23 January 2007 12:03 Go to previous message
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

Previous Topic: How to post doubts on Oracle Faqs site
Next Topic: Difference between Oracle 9i & 10g
Goto Forum:
  


Current Time: Fri Nov 29 22:02:16 CST 2024