Re: cursor not open error (error code :1326)

[Devart Team]

You are trying to close the cursor c1 twice. First time - after the 'if no_rows' condition, and second time - at the end. Have a look at this example - Cursors.

Try to debug your sp with a code debugger. It will help to understand what happened.

Also, you might resolve your task with INSERT...SELECT statement, without any cursors, i.e. -

INSERT INTO customertrans(customerID) SELECT customerID from master;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/