title: How to fetch data from remote oracle database Ruby on rails
body: <p>I want to fetch data from a remote Oracle database and display it on my web page how do i do that ?</p>
  
  <p>despite i have successfully connected to the remote database by modifying the database.yml and using SQL developer to test out the connection.</p>
  
  <p>Ruby version :2.6.5
  Rails version : 6.0.2.1
  database version: 19c</p>
  
  <p>*
  I have oracle instant client setup as well as the oracle gem and i can connect to the remote database however i still can't fetch data from the remote DB</p>
  
  <p><strong>Due to this error</strong> </p>
  
  <p>Puma caught this error: '{ development => }' is not a valid configuration. Expected '' to be a URL string or a Hash. (ActiveRecord::DatabaseConfigurations::InvalidConfigurationError)</p>
  
  <p><strong>my database.yml</strong></p>
  
  <p><strong>default: &amp;default</strong></p>
  
  <p>adapter: oracle_enhanced</p>
  
  <p>pool: &lt;%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %></p>
  
  <p>host: link to server</p>
  
  <p>database: dbname</p>
  
  <p>username: dbuser</p>
  
  <p>password: dbpass</p>
  
  <p>port: portnum</p>
  
  <p><strong>development:</strong></p>
  
  <p>adapter: oracle_enhanced</p>
  
  <p>username: dbuser</p>
  
  <p>password: dbpass</p>
  
  <p>database: serverlink/dbname</p>