Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Stored procedure
Sat, Apr 12 2008 12:46 PMPermanent Link

Dieter Nagy
I wrote this procedure

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.

What do I wrong?
TIA
Dieter
Sun, Apr 13 2008 3:04 AMPermanent Link

Dieter Nagy
Sorry for this post, I found the error.

Dieter
Image