Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# SW_GETCASE_STATUS

The `SW_GETCASE_STATUS` procedure returns the status of a case of a procedure.

## Syntax

    SW_GETCASE_STATUS (
    case_numin integer,case_statusout varchar(10),proc_typeout varchar(10),case_startedout 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine