Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while calling Workflow APIs remotely

292099Oct 4 2002

I have standalone workflow engine. I have created views and workflow packages in another databases. These packages are calling workflow APIs internally using DB Link. I call these packages inside Powerbuilder. I start process from the PowerBuilder, process started successfully. User responded to the notification by logging into powerbuilder, it is also successful.

But when user responds to last notification to END the process, I am getting following error:

ORA-02074: cannot ROLLBACK in a distributed transaction
ORA-06512: at "OWF_MGR.WF_ENGINE_UTIL", line 1263
ORA-02074: cannot SET SAVEPOINT in a distributed transaction

Is it wrong to call Workflow APIs remotely ? Any solution ?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2002

Added on Oct 4 2002

#database-key-features, #workflow

2 comments

305 views