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?

1 Like