sanjay soni wrote : >Hi, I have written the following stored procedure. It is not getting compiled and giving me following error. >General error;-8014 POS(290) Result table must be FOR REUSE:ALLJOBPAGES. >Can you please help me out!
>CREATE DBPROC STAT_CUSTOMERNAME RETURNS CURSOR AS >BEGIN >DECLARE ALLJOBPAGES CURSOR FOR >SELECT JOBDETAILS.JOBID, JOBDETAILS.DUEDATE >FROM PMP_OWNER.JOBDETAILS; >END; >$CURSOR = 'CURSOR2'; >DECLARE :$CURSOR CURSOR FOR >SELECT * FROM PMP_OWNER.ALLJOBPAGES; If you want to reuse a cursor in a following query, the cursor must be opened with the FOR REUSE option : CREATE DBPROC STAT_CUSTOMERNAME RETURNS CURSOR AS BEGIN DECLARE ALLJOBPAGES CURSOR FOR SELECT JOBDETAILS.JOBID, JOBDETAILS.DUEDATE FROM PMP_OWNER.JOBDETAILS FOR REUSE; END; $CURSOR = 'CURSOR2'; DECLARE :$CURSOR CURSOR FOR SELECT * FROM PMP_OWNER.ALLJOBPAGES; However, in your case reusing the cursor seems to make no sense, because it can be returned directly without creating a copy : CREATE DBPROC STAT_CUSTOMERNAME RETURNS CURSOR AS BEGIN $CURSOR = 'CURSOR2'; DECLARE :$CURSOR CURSOR FOR SELECT JOBDETAILS.JOBID, JOBDETAILS.DUEDATE FROM PMP_OWNER.JOBDETAILS; END; Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
