I want to switch from sql server to apache Derby for my project .
I wanna run a procedure like this in apache derby .
create procedure testProcedure( @personid Integer )
select fullName , fatherName, age, income, grosssalary from persons where personid = @personid ;
But it is not working .
How could i write this procedure in apache derby !!
Thanks & Regards !!
Dheeraj Dhiman !!