How do I access raw Oracle OCI8 database handle?

Rails
1

Hi, I know about the connection() routine in ActiveRecord::Base, but
that gives you the ActiveRecord adapter, not the real OCI8 “dbh”
database handle.

I’d like to do something like this:

class MyModel < ActiveRecord::Base
def some_method
dbh = connection()
dbh.prepare(“BEGIN some_procedure(?,?,?); END;”)
dbh.execute(arg1, arg2, arg3)
end
end

Anybody able to do this? I know it goes around ActiveRecord, but I have
a number of stored procedures I need to access (DBA’s require it for
this app)

Thanks,
Nate

2

Nate wrote:

Hi, I know about the connection() routine in ActiveRecord::Base, but
that gives you the ActiveRecord adapter, not the real OCI8 “dbh”
database handle.
[snip]
Anybody able to do this?

ActiveRecord::Base.connection.raw_connection.parse

Dan M.