Re: Error in procedure creation
Posted by:
Rod Sherer
Date: March 10, 2009 08:17AM
My guess (based on a weeks experience with MySql) is that you have to have all your DECLARE statements at the beginning of your BEGIN/END block. If you put another BEGIN/END block inside your driving loop, it may solve the issue with the second cursor declaration.
However, some people will ask why you didn't just join the second query to the query in your driving loop so you wouldn't need a second loop.
Subject
Views
Written By
Posted
3467
March 01, 2009 03:33PM
Re: Error in procedure creation
2248
March 10, 2009 08:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.