Topic: 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?