Oracle Singleton working in Ruby

gistfile1.rb

[1] pry(main)> require './detpd270'
Warning: NLS_LANG is not set. fallback to US7ASCII.
=> true
[2] pry(main)> c = Connection.instance.conn
=> #<OCI8:LUKENAX>
[3] pry(main)> c.exec('select * from dual') { |results| puts results }
X
=> 1
[4] pry(main)> c.exec("select sysdate, to_char(sysdate, 'YYYYMMDD') from dual") { |results| puts results }
2013-02-01 12:50:06 -0500
20130201
=> 1
[5] pry(main)> c.exec("select sysdate, to_char(sysdate, 'YYYYMMDD') from dual") { |results| puts results.join ',' }
2013-02-01 12:50:25 -0500,20130201
=> 1
[6] pry(main)>