This discussion is archived
1 Reply Latest reply: Sep 11, 2007 1:52 PM by NoLongerActive RSS

ORA-04061 error

534603 Newbie
Currently Being Moderated
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.

Thanks in advance for any help!
  • 1. Re: ORA-04061 error
    NoLongerActive Pro
    Currently Being Moderated
    Hi,

    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.

    Matt
    --
    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