how to use cursor in Sp in MySql

usp_CheckItemReceipt
(
@result int out,
@ItemCode nchar (10),
@Qty int,
@InvoiceId int
)
AS
DECLARE @QtyRecd int
DECLARE @Qtyissued int
DECLARE @get_rcptkey cursor

set @get_rcptkey = CURSOR FOR
select sum(qty) from Receiptdetail where Itemcode = @ItemCode and invoiceid = @InvoiceId

OPEN @get_rcptkey

FETCH NEXT FROM @get_rcptkey into @QtyRecd


CLOSE @get_rcptkey

set @get_rcptkey = CURSOR FOR
select qty from invoicedetail inner join invoice on invoice.invoiceid = invoicedetail.invoiceid where Itemcode = @ItemCode and invoiceno = @InvoiceId

OPEN @get_rcptkey
FETCH NEXT FROM @get_rcptkey into @Qtyissued

if (@QtyRecd + @Qty) > @Qtyissued

set @result= 0

else

set @result= 1

CLOSE @get_rcptkey
DEALLOCATE @get_rcptkey