Topic: Regarding Oracle stored procedure with Rails application
I am using Oracle with Rails application, but I am getting an error while executing Strored procedure.
Create procedure test1(i in number)
insert into t2 values(i,'abc');
It's working fine.
Create procedure test2(i in number)
select nam from t2 where numb=1;
Now it's not running giving error: test2 is an invalid option.
Can anybody help?