Call an Oracle function

Hi all,
I need to call a Oracle function from Rais.Does anyone have some
experience with it?

Thanks,
Rafael

If you just want to call a function you could do something like

results = ActiveRecord::Base.connection.select_all “select my_function
(‘some argument’) value from dual”
puts results.first[‘value’]

For example

ActiveRecord::Base.connection.select_all “select 7+5 value from dual”
=> [{“value”=>12}]

If you have a more complicated plsql stored procedure that maybe sets
more than one result parameter you can use the plsql gem
http://github.com/rsim/ruby-plsql. This gem lets you call arbitrary
plsql procedures with any input or output parameters.

Hope this helps
–Alex

On Oct 27, 8:10 am, Rafael R. [email protected]

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs