Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix C SSOLite Stored Procedures : Command Procedures : SW_CASEREOPEN

SW_CASEREOPEN
The SW_CASEREOPEN procedure resurrects a case.
Syntax
SW_CASEREOPEN (
proc_name in varchar2(8),
user_id in varchar2(24),
step_name in varchar2(8),
case_num in integer)
where:
proc_name is the name of the procedure that you want to resurrect.
user_id is the name of the iProcess user who is resurrecting the case.
step_name is the name of the case step that you want to resurrect.
case_num is the number of the case that you want to resurrect.
Notes
After a case is closed, all the deadlines of the case are removed. If the case is reopened, you can reset the deadlines by running the CreateCaseDeadline function. For more information about the CreateCaseDeadline function, see TIBCO iProcess Expressions and Functions Reference Guide.
Example
This example resurrects step STEP1 of case 101 of procedure CUSTREQ.

 
EXEC ssolite.SW_CASEREOPEN ('CUSTREQ', 'user35','STEP1',101);

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved