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 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]