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


Appendix C SSOLite Stored Procedures : Command Procedures : SW_GETCASE_STATUS

SW_GETCASE_STATUS
The SW_GETCASE_STATUS procedure returns the status of a case of a procedure.
Syntax
SW_GETCASE_STATUS (
case_num in integer,
case_status out varchar(10),
proc_type out varchar(10),
case_started out date)
where:
case_num is the number of the case that you want to get the status of.
case_status (output) is the name of a variable, defined in the calling program, into which SW_GETCASE_STATUS will return the status of the specified case.
proc_type (output) is the name of a variable, defined in the calling program, into which SW_GETCASE_STATUS will return the procedure type of the specified case (for example, Main or Sub).
case_started (output) is the name of a variable, defined in the calling program, into which SW_GETCASE_STATUS will return the date that the case was started.
Example
This example displays the status of case 8.

 
Declare
case_status varchar(10);
proc_type varchar(10);
case_started date;
begin
         SSOLITE.SW_GETCASE_STATUS (8, case_status, proc_type, case_started);
        DBMS_OUTPUT.PUT_LINE('Case status is ' ||case_status);
        DBMS_OUTPUT.PUT_LINE('Proc type is ' ||proc_type);
        DBMS_OUTPUT.PUT_LINE('Case started at ' || case_started);
end;
/

 
This results in output displaying the status of the case. For example:

 
Case status is Active
Proc type is Sub
Case started at 31-MAY-05

 

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