Do not use an EXECUTE, SELECT, or WITH keyword as the name of a cursor. If you try to use one of these keywords as the name of a cursor in a FOREACH statement, the cursor name is interpreted as a keyword in the FOREACH statement. No workaround exists.
The following example does not work:
DEFINE execute INT;
FOREACH execute FOR SELECT col1 -- error, looks like
-- FOREACH EXECUTE PROCEDURE
INTO var1 FROM tab1;
Enterprise Edition Home |
Express Edition Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]