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?