Method: OraUtils::OracleAccess#sql_on

Defined in:
lib/orabase/utils/oracle_access.rb

#sql_on(sids, command, parameters = {}) ⇒ Object

Use this function to execute Oracle statements on a set of specfied sids

Parameters:

  • sids (Array) —

    Array of SIDS

  • command (String) —

    this is the commands to be given



22
23
24
25
26
27
28
 
# File 'lib/orabase/utils/oracle_access.rb', line 22

def sql_on( sids, command, parameters = {})
  results = []
  sids.each do |sid|
    results = results + sql(command, {:sid => sid}.merge(parameters))
  end
  results
end