I'm hoping someone can shed some light on a problem we are having. We have a number of workflow processes that call routines in a database packages. Everytime the package is recompiled, the next time the workflow process runs it errors with the following message:
ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body
(this is exact, it does not put anything between the words "of" and "has").
This is bogus because the package is NOT invalid in the database. So, why is WF returning this?
Part Two: what is the easiest way to fix it when it happens. Sometimes stopping and then starting the WF listeners works, but not always. Plus this is a pain because this is happening a lot in our development instance as we have a lot of developers creating routines used by WF.
This is "expected" functionality - i.e. it's fairly common, but has never been fixed satisfactorily.
Have a look at my blog, my thoughts on this (and how to avoid it) are there.
WorkflowFAQ.com - the ONLY independent resource for Oracle Workflow development
Alpha review chapters from my book "Developing With Oracle Workflow" are available via my website http://www.workflowfaq.com
Have you read the blog at http://thoughts.workflowfaq.com ?
WorkflowFAQ support forum: http://forum.workflowfaq.com