Problem with the WF - error with the commit statment
I would appriciate help on OM WF.
Created a Custom WF to release order line holds, I get an errror 3146: Commit happened in activity/function
I understand that it has to do with the commit I perform in the Package, but how can I fix it?
Also, the reason it errors is that there is an returned error, but why, its a simple Procedure:
PROCEDURE XXCSR_RELEASE_LINE_HOLDS(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2) AS
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;