Ruby on Rails
HowToOracleStoredProcedures

Using Oracle stored procedures with Rails properly is not as hard as it seems. A quick example:

  conn = ActiveRecord::Base.connection.raw_connection
  proc = conn.parse("BEGIN P_MYPROCEDURE.my_method(:out); END;")
  proc.bind_param(':out', OCI8::Cursor) 
  proc.exec

  cursor = proc[':out']
  proc.close

  x = ''
  while r = cursor.fetch()
    x = x + r.join(', ') + '<br>'
  end

you can find more things you can do with raw_connection here