"select into " statements must be return one row.

----- Original Message -----
From: Francisco Antonio Vieira Souza
To: Firebird-Java@yahoogroups.com
Sent: Friday, May 28, 2004 3:21 PM
Subject: [Firebird-Java] GDS Exception


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


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

b.. To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.691 / Virus Database: 452 - Release Date: 26/05/2004

[Non-text portions of this message have been removed]