CREATE PROCEDURE [dbo].[up_OK_BRO_S_TrudSpisok]
                                        @Help  char(2)=null,
                                        @Debug char(3)='OFF',

                                        @ViewFlag int
AS
BEGIN
 
 SET NOCOUNT ON
 
 IF @Help IS NULL GOTO Help
 IF @Debug='ON' PRINT 'Dedug=ON'
 
 IF @ViewFlag=2
 BEGIN
 SELECT A.[IDTrud], A.[TabNo],
        RTRIM(A.[Fam]) AS [Fam], RTRIM(A.[Name]) AS [Name],  RTRIM(A.[Otch]) AS [Otch],
        A.[WorkStatus],
        CASE A.[WorkStatus]
         WHEN 0 THEN ''
         WHEN 1 THEN 'ó'
         WHEN 2 THEN '?'
        END AS [WStatusSTR],
        G.[NameDol], R.[NameRazr],
        CONVERT(CHAR(10), A.[DateIn], 103) AS [DateInSTR],
        CASE A.[WorkStatus]
         WHEN 0 THEN ''
         WHEN 1 THEN CONVERT(CHAR(10), A.[DateOut], 103)
         WHEN 2 THEN ''
        END AS [DateOutSTR]

 FROM [dbo].[OK_WTB_Trud] AS A
      LEFT OUTER JOIN [dbo].[SR_ALL_Dolzh] AS G
      ON A.[IDDolzh]=G.[IDDolzh]
      LEFT OUTER JOIN [dbo].[SR_ALL_Razr] AS  R
      ON A.[IDRazr]=R.[IDRazr]

 ORDER BY A.[Fam] ASC,
          A.[Name] ASC,
           A.[Otch] ASC

 END--@ViewFlag=1
 

 IF @ViewFlag IN (0,1)
 BEGIN
 SELECT A.[IDTrud], A.[TabNo],
        RTRIM(A.[Fam]) AS [Fam], RTRIM(A.[Name]) AS [Name],  RTRIM(A.[Otch]) AS [Otch],
        A.[WorkStatus],
        CASE A.[WorkStatus]
         WHEN 0 THEN ''
         WHEN 1 THEN 'ó'
         WHEN 2 THEN '?'
        END AS WStatusSTR,
        G.[NameDol], R.[NameRazr],
        CONVERT(CHAR(10), A.[DateIn], 103) AS [DateInSTR],
        CASE A.[WorkStatus]
         WHEN 0 THEN ''
         WHEN 1 THEN CONVERT(CHAR(10), A.[DateOut], 103)
         WHEN 2 THEN ''
        END AS [DateOutSTR]

 FROM [dbo].[OK_WTB_Trud] AS A
      LEFT OUTER JOIN [dbo].[SR_ALL_Dolzh] AS G
      ON A.[IDDolzh]=G.[IDDolzh]
      LEFT OUTER JOIN [dbo].[SR_ALL_Razr] AS  R
      ON A.[IDRazr]=R.[IDRazr]

 WHERE A.[WorkStatus]=@ViewFlag
 
 ORDER BY A.[Fam] ASC,
          A.[Name] ASC,
           A.[Otch] ASC

 END--@ViewFlag=in
 GOTO EndProc

Help:
 PRINT '--------------------------------------------------------------------------------'
 PRINT 'Description  :        '
 PRINT '--------------------------------------------------------------------------------'
 RETURN -1

EndProc:
END

public class GetListTrud
{           
    private CallableStatement сst;
    private ResultSet rs;
    private Boolean fillDataResult;
    private String fillDataStr;
    
    //constructors
    public GetListTrud()
      {                
        сst=null;
        rs=null;
        fillDataResult=false;
        fillDataStr   ="";       
      }

    
    //methods, etc       
    
         
    //заполняем данными список    
    public void FillData(Connection con, String DBName, Integer viewflag)           
      {
       if (con==null) {return;};
       
       if (viewflag<0 | viewflag>2 | DBName.length()==0) 
       {
           this.fillDataResult=false;
           this.fillDataStr="Неверные параметры для выполнения SP.";
           return;
       }                           
       try
          {
              this.fillDataResult=true;           
              сst=con.prepareCall("{call [dbo].[up_OK_BRO_S_TrudSpisok](?,?,?)}");
              сst.setString(1, "NH");
              сst.setString(2, "OFF");
              сst.setInt(3, viewflag);
       
              rs=сst.executeQuery();                            
              
          } catch (Exception e)
          {
           this.fillDataResult=false;
           this.fillDataStr="Невозможно выполнить SP:"+"<br>"+e.getMessage();
          }
      }//filldata
                 
    
  }

Невозможно выполнить SP:
Инструкция не вернула результирующий набор. 

import java.sql.*;

public class GetListTrud
 {
    private Connection c;
    private Integer viewflag;
    //private Statement cst;
    private PreparedStatement cst;
    private ResultSet rs;
    private Boolean fillDataResult;
    private String fillDataStr;
    
    //constructors
    public GetListTrud()
      {        
        c=null;
        viewflag=-1;
        cst=null;
        rs=null;
        fillDataResult=false;
        fillDataStr   ="";       
      }

    public GetListTrud(Connection con, Integer viewflag)
      {
        this.c=con;
        this.viewflag=viewflag;
        cst=null;
        rs=null;
        fillDataResult=false;
        fillDataStr   ="";  
      }
    
    //methods, etc       
    public ResultSet getRs()
      {
        return rs;        
      }

    public Boolean getFillDataResult()
      {
        return fillDataResult;
      }

    public String getFillDataStr()
      {
        return fillDataStr;
      }
    
         
    //заполняем данными список    
    public void FillData()  
      {
       if (c==null) 
       {
         this.fillDataResult=false;
         this.fillDataStr="Неверные параметры для выполнения SP. (c=null)";
         return;
       }       
       if (viewflag<0 | viewflag>2) 
       {
         this.fillDataResult=false;
         this.fillDataStr="Неверные параметры для выполнения SP. (viewflag="+viewflag.toString()+")";
         return;
       }                      
       try           
          {
            this.cst = c.prepareStatement("{call [dbo].[up_OK_BRO_S_TrudSpisok](?,?,?)}");
            this.cst.setString(1, "'NH'");
            this.cst.setString(2, "'OFF'");
            this.cst.setInt(3, 0);
            this.rs = cst.executeQuery();              
            this.fillDataResult=true;
             
          } catch (Exception e)
          {
           this.fillDataResult=false;
           this.fillDataStr="Невозможно выполнить SP:"+"<br>"+e.getMessage();          
          }
      }//filldata
          
    
    public void CloseStatement()
      {
        if (this.rs!=null) 
        {
            try
            {
             rs.close();    
            } catch (Exception e)
            {
            }
            
        }
        if (this.cst!=null) 
        {         
            try
            {
              this.cst.close();     
            } catch (Exception e)
            {
            }
        }
      }
    
  }

this.cst.setInt(3, 0);

this.cst.setInt(3, this.viewflag);