AS400 Stored Procedures

[Cowboy Bob]

Doh, there was a continue handler up at the top of the procedure which set endCursor to -1 meaning the while loop was never entered. Yet the debugger implied that the delete statement was being run

I hate this machine...

[Cowboy Bob]

I'm trying to delete a bunch of records based on the results from a cursor. It's not throwing an error, but no delete is happening.

This works:-

OPEN priceDetailsCursor;
	
FETCH priceDetailsCursor INTO priceDetailsPrimaryKey;
	
--WHILE (endCursor = 0) DO
	DELETE FROM MMNBDLIB.PRCTAX WHERE FKPRCDET = priceDetailsPrimaryKey;
--	SET endCursor = -1;
--END WHILE;
	
CLOSE priceDetailsCursor;

This doesn't:-

OPEN priceDetailsCursor;
	
FETCH priceDetailsCursor INTO priceDetailsPrimaryKey;
	
WHILE (endCursor = 0) DO
	DELETE FROM MMNBDLIB.PRCTAX WHERE FKPRCDET = priceDetailsPrimaryKey;
	SET endCursor = -1;
END WHILE;
	
CLOSE priceDetailsCursor;

In the "Explain SQL" option in the iSeries Navigator it says "SQL5065 Access plan not found." when it tries to do the delete, but no exception is thrown. priceDetailsPrimaryKey is being set to the correct value as I've checked by setting an out parameter to its value. I've Googled to no avail. Anyone got any ideas?