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?

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs