sorry , I called like ActiveRecord::Base.connection.select_all "exec testproc 'test' out " but still get ORA-00900: invalid SQL statement
On Jan 20, 4:31 pm, [email protected] wrote: > Hi all , > I tried to call oralce store procedure in rails , but it fails . any > body have experience about it ? thanks George > > the procedure is like this: > CREATE OR REPLACE PROCEDURE testproc ( > input IN VARCHAR2 , > output OUT VARCHAR2) > AS > BEGIN > output := input ; > END ; > > I called it in rails console like this : > ActiveRecord::Base.connection.select_all "exec testproc out " > > but failed , it says ORA-00900: invalid SQL statement --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ruby-on-rails-programming-with-passion" group. To unsubscribe from this group, send email to ruby-on-rails-programming-with-passion-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/ruby-on-rails-programming-with-passion?hl=en?hl=en -~----------~----~----~----~------~----~------~--~---
