PROCEDURE "Probe1" (IN "ID" INTEGER)
BEGIN
DECLARE Result CURSOR WITH RETURN FOR Stmt;
BEGIN
PREPARE Stmt FROM 'SELECT * from probe where z1 = ?';
Open result using ID;
END;
END
In ElevateDBManager I got 0 records.
When I replace the "?" with a real number then the proc works fine.