Hi,
I am getting following error when executing the SP from .Net

"multiple rows in singleton select"

But, the SP doesn't contain any select (from table) statement. Just
few Insert and two statements like -

sp:

DECLARE VARIABLE prodid INTEGER;
DECLARE VARIABLE ProductID INTEGER;
BEGIN
INSERT INTO products ..

SELECT GEN_ID("MY_GENERATOR" , 0) FROM products INTO :prodid;
IF (:prodid IS NOT NULL) THEN
BEGIN
INSERT INTO A ..
INSERT INTO B ..
INSERT INTO C ..
END

SELECT GEN_ID("MY_GENERATOR" , 0) FROM products INTO :ProductID;
SUSPEND;
END


Is this because of select gen_id(..)?

Thanx in advance for any help.

Cheers,
Ghanshyam.