Call an Oracle function

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


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
GitHub - rsim/ruby-plsql: ruby-plsql gem provides simple Ruby API for calling Oracle PL/SQL procedures. It could be used both for accessing Oracle PL/SQL API procedures in legacy applications as well as it could be used to create PL/SQL unit tests using Ruby testing libraries.. This gem lets you call arbitrary
plsql procedures with any input or output parameters.

Hope this helps

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