gistfile1.rbx

#Note: did not work with SQL Server, will work with Oracle, MySQL
#require AR
require 'rubygems'
require 'active_record'

# connect to the Database
ActiveRecord:: Base.establish_connection(
:adapter => "oracle",
:database => "172.30.10.140/xe",
:username => "prep",
:password => "pass"
)

#define a simple model
class PcoOutboundqueue < ActiveRecord::Base
set_table_name "PCO_OUTBOUNDQUEUE" # comment out if not using oracle
end

begin
  record=PcoOutboundqueue.find(:first)
puts record.inspect
  rescue => err
  puts err
end