This doesn’t answer your question directly, but you might want to read about how to obtain Oracle debug output in your Rails app/log file:
http://www.alexrothenberg.com/2009/08/how-to-capture-oracles-dbmsoutput-in.html I believe Alex’s patch was recently added to the Oracle Enhanced Adapter... if you’re using that and upgrade to the latest version that includes the patch, you’ll be able to put some debug/log code in your PL/SQL and get maybe get some idea of what’s going on. - pat http://patshaughnessy.net On Oct 22, 2:43 pm, Hassan Schroeder <[email protected]> wrote: > On Thu, Oct 22, 2009 at 11:37 AM, Rafael Roque > > <[email protected]> wrote: > > > It should return me two integers,but it´s returning "1". > > OK, sorry -- I don't know anything about Oracle procedures, but if I > execute a query using ActiveRecord::Base.connection.execute(sql) > it returns a resultset, e.g. (via script/console) > > >> result = ActiveRecord::Base.connection.execute("select 1") > > => #<Mysql::Result:0x1fe43a8> > > >> result.fetch_row > => ["1"] > > HTH, > -- > Hassan Schroeder ------------------------ [email protected] > twitter: @hassan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
