Subject GDS Exception
Author Francisco Antonio Vieira Souza
Any tip about this exception?
GDS Exception. 335544652. multiple rows in singleton select

ps = c.prepareStatement("SELECT * FROM CONSULTA_ITENS_NOTA(?,?)");
ps.setInt(1, numero);
ps.setString(2, cnpj);
rs = ps.executeQuery();

SET TERM !!;
CREATE PROCEDURE CONSULTA_ITENS_NOTA(xNUM INTEGER, xFOR VARCHAR(18))
RETURNS(CODIGO_PRODUTO VARCHAR(25),
QUANTIDADE NUMERIC(14,3),
PESO NUMERIC(14,3))
AS
BEGIN
SELECT CODIGO_PRODUTO,
QUANTIDADE,
PESO FROM INSUMO_NOTA
WHERE NOTA_FISCAL=:xNUM AND FORNECEDOR=:xFOR
INTO :CODIGO_PRODUTO, :QUANTIDADE, :PESO;
SUSPEND;
END!!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004