How to use gem ruby_plsql with JRuby
October 4th, 2008
That is just the basic configuration. Hope that helps.
enviroment.rb
config.gem “ruby-plsql”, :lib => “ruby_plsql”
models/some_model.rb
require “ruby_plsql”
class SomeModel < ActiveRecord::Base
def persist
plsql.connection = ActiveRecord::Base.connection.
raw_connection.connection
appraisal_id = plsql.bra_customhr_eval_pk.create_appraisal(
:p_employee_number => self.appraisee.employee_number,
:p_appraisal_template_id => @avalTemplate[0].template_id,
:p_period_start_date => @avalTemplate[0].valid_from,
:p_period_end_date => @avalTemplate[0].valid_until,
:p_business_group_id => self.appraisee.business_group_id,
:p_employee_number => self.appraisee.employee_number,
:p_appraisal_template_id => @avalTemplate[0].template_id,
:p_period_start_date => @avalTemplate[0].valid_from,
:p_period_end_date => @avalTemplate[0].valid_until,
:p_business_group_id => self.appraisee.business_group_id,
:p_appraisal_id => nil,
:p_object_version_number => nil)[:p_appraisal_id
end
end
