Displaying 1 result from an estimated 1 matches for "our_db".
Did you mean:
your_db
2006 Nov 04
0
Problems with ActiveRecord, Oracle adapter, find_by_sql, multi-table join - ORA-04043 error
...uilding_id
AND b.main_address = cl.cust_loc_id
AND cl.location_id = loc.location_id
So, I setup a class for the ''Location'' table like this:
class OracleLocation < ActiveRecord::Base
establish_connection(
:adapter => "oracle",
:database => "our_db",
:username => "user",
:password => "password"
)
set_table_name :location
set_primary_key "location_id"
end
I can get a record back just fine:
loc = OracleLocation.find_by_sql(sql).first
p loc
#<OracleLocation:0x385c610 @attrib...