gistfile1.txt

class Mysql
  def proc(str)
    DB.query_with_result = false
    
    resultsets = []
    

    no_more_results=false

    DB.query( %(call #{str}) )
    
    until no_more_results 

      begin

        rs = DB.use_result

      rescue Mysql::Error => e

        no_more_results = true

      end
      

      if no_more_results == false
        resultset = []
        
        rs.each_hash do |row|
          resultset << row
        end
        
        resultsets << resultset
        
        rs.free
        

        DB.next_result

      end

    end
    
    resultsets
  ensure
    DB.query_with_result = true
  end
end