Rails - Feb 2007 - Regarding Oracle stored procedure with Rails application

Hi,

I am using Oracle with Rails application, but I am getting an error while
executing Strored procedure.


Create procedure test1(i in number)
as
begin
insert into t2 values(i,''abc'');
end test1;
.
run;

execute test1(8);

It''s working fine.

*But*
**
Create procedure test2(i in number)
as
begin
select nam from t2 where numb=1;
end test2;
.
*run;*


Now it''s not running giving error: test2 is an invalid option.


Can anybody help?

--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---