Hello !!
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 !!