how to use cursor in Sp in MySql

Question

Hello everyone.
i m facing problem while creating procedure in MySql.
i create the same sp in sql server and its working fine but when i try to use it in mysql it showing errors.
i attached my sp code file and the details are below
this sp is restrict user to received quantity more then issue. (if invoice show 10 issue then this sp check receive upto 10 and giver error message if user try to receive more then issue)
please help me if anyone who get my point.
please make the req,. chances.
thanks a lot
Regards
Rashid

Suthish Nair · Answer

Please accept the post as answer if your query is resolved. Thank You.

Suthish Nair · Answer

check this tool

Sam Hobbs · Answer

Okay sorry; so you need to convert the SQL Server stored procedure for use with MySQL? I hope someone can help with that.

Rashid Khan · Answer

Yes. now i want in Mysql i hope u understand wht tht sp is working Thanks

Sam Hobbs · Answer

I discovered that 7-zip can extract from rar files. So I posted your code below. I did not modify it except to add formatting. Does the following look like your stored procedure? 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

Rashid Khan · Answer

see i attached txt file and this site cannot upload it. or you can give me or email address i'll send it over there

Rashid Khan · Answer

thanks for the reply. this website allows rar file anyway i m sending again my sp which is written in sql server and when i try to create in mysql it shows error. syntax error in many lines(specially near of SET nd CURSOR) please find the attachment thanks Regards Rashid

Sam Hobbs · Answer

I can't open rar files. I think this web site should not allow rar files to be uploaded. Are you sure you provide information about the error? Whenever you get an error message you need to provide the complete and accurate error message when you need help with an error.