create procedure sp_get_products
  @items_per_page int =  20 ,
  @page int =  1 ,
  @order_field varchar( 255 ) = 'product',
  @group_id int = null,
  @artist_del varchar( 10 ) = ', ',
  @order_dir varchar( 4 ) = 'asc'
as begin
...

      String qry = "{call sp_get_products(?, ?, ?, ?, ?, ?)}";
      CallableStatement cs = con.prepareCall(qry);
      cs.setInt( 1 ,  30 );
      cs.setInt( 2 ,  3 );
      cs.setString( 3 , "product");
      cs.setInt( 4 ,  7 );
      cs.setString( 5 , ", ");
      cs.setString( 6 , "desc");

      cs.execute();
       boolean  no = (!cs.getMoreResults()) && (cs.getUpdateCount() == - 1 );
      cs.close();

      System.out.println(no);