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