Subject Problem in SP
Author Francisco Antonio Vieira Souza
I dont know if the problem is related to JayBird but I am asking for help
anyway.
I never could execute a SP from my aplication without this error, actually I
had given up, but I decided to try again, so the error came again:

GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 59
)

SET TERM !!;
CREATE PROCEDURE CAD_NOTA_ENTRADA(
xNUMERO INTEGER,
xFORNECEDOR VARCHAR(18),
xEMISSAO DATE,
xESPECIE VARCHAR(30),
xNATUREZA VARCHAR(30),
xVALOR_TOTAL NUMERIC(13,5),
xVALOR_ICMS NUMERIC(13,5),
xVALOR_IPI NUMERIC(13,5))
AS
BEGIN
INSERT INTO NOTAS_ENTRADAS(NUMERO,
FORNECEDOR,
DATA_EMISSAO,
ESPECIE,
NATUREZA,
VALOR_TOTAL,
VALOR_ICMS,
VALOR_IPI)
VALUES(:xNUMERO,
:xFORNECEDOR,
:xEMISSAO,
:xESPECIE,
:xNATUREZA,
:xVALOR_TOTAL,
:xVALOR_ICMS,
:xVALOR_IPI);

END!!
int codigo = Integer.parseInt(campoNumeroNota.getText());
java.sql.Date data_emissao =
T.setDate(campoDataEmissao.getText());
String cnpj_fornecedor =
(String)htCNPJ.get((String)cbFornecedor.getSelectedItem());
String especie = campoEspecie.getText();
String natureza = campoNatureza.getText();

BigDecimal valor_icms =
(BigDecimal)campoValorICMS.getValue();
BigDecimal valor_ipi =
(BigDecimal)campoValorIPI.getValue();
BigDecimal valor_nota =
(BigDecimal)campoValorTotal.getValue();

c.setAutoCommit(false);

PreparedStatement stm = c.prepareCall("{call CAD_NOTA_ENTRADA(?,
?, ?, ?, ?, ?, ?, ?) }");
stm.setInt(1, codigo);
stm.setString(2, cnpj_fornecedor);
stm.setDate(3, data_emissao);
stm.setString(4, especie);
stm.setString(5, natureza);
stm.setBigDecimal(6, valor_nota);
stm.setBigDecimal(7, valor_icms);
stm.setBigDecimal(8, valor_ipi);
stm.execute();
stm.close();

Thanks.
---
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