Ayuda con Funcion

From: NachXs <nachxs(at)gmail(dot)com>
To: "List Postgresql" <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Ayuda con Funcion
Date: 2008-01-05 04:48:53
Message-ID: 6e08b4840801042048j3435fbdchb08c5efc96c6266f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola amigos, primero que todo Feliz Año 2008 para todos, los mejores deseo
para esta nuevo año.
Bueno recurro a Ud por un pequeño problemita que se me esta presentando a la
hora de llamar a una funcion desde java, estoy revisando la funcion varias
veces para dar con el problema pero la verdad no puedo dar con el error
quizas algunos de Uds que me pueda apoyar.
Esta es mi funcion:

CREATE OR REPLACE FUNCTION sp_insert_cabezera_sbs(des_alf character varying,
cod_sbs_in character varying, fec_mov bpchar, tip_doc_tri bpchar,
num_doc_tri bpchar, tip_doc_ide bpchar, num_doc_ide bpchar, tip_per bpchar,
num_emp_rep bpchar, c00 numeric, c01 numeric, c02 numeric, c03 numeric, c04
numeric, importe numeric, ape_pat character varying, ape_mat character
varying, ape_cas character varying, nom_1 character varying, nom_2 character
varying, t00 numeric, t01 numeric, t02 numeric, t03 numeric, t04 numeric,
t0t numeric, pc00 numeric, pc01 numeric, pc02 numeric, pc03 numeric, pc04
numeric, pc0t numeric, com_mes numeric, ind_caja bpchar, bco_malo_01 bpchar,
bco_malo_02 bpchar, bco_malo_03 bpchar, bco_malo_04 bpchar, bco_malo_05
bpchar, deuda_consumo numeric, deuda_total numeric, ind_castigo bpchar,
deuda_hipotecaria numeric, deuda_bco_01 numeric, deuda_bco_02 numeric,
deuda_bco_03 numeric, deuda_bco_04 numeric, deuda_bco_05 numeric)
RETURNS integer AS
$BODY$

DECLARE
val int;
cod_sbs_cab varchar(16);

BEGIN
val = 0;
Select cod_sbs Into cod_sbs_cab from cli$pos_cli_sbs_cab where cod_sbs =
cod_sbs_in;
If cod_sbs_cab is null then
insert into cli$pos_cli_sbs_cab
values(des_alf,cod_sbs_in,fec_mov,tip_doc_tri,
num_doc_tri,
tip_doc_ide,
num_doc_ide,
tip_per,
num_emp_rep,
c00,
c01,
c02,
c03,
c04,
importe,
ape_pat,
ape_mat,
ape_cas,
nom_1,
nom_2,
t00,
t01,
t02,
t03,
t04,
t0t,
pc00,
pc01,
pc02,
pc03,
pc04,
pc0t,
com_mes,
ind_caja,
bco_malo_01,
bco_malo_02,
bco_malo_03,
bco_malo_04,
bco_malo_05,
deuda_consumo,
deuda_total,
ind_castigo,
deuda_hipotecaria,
deuda_bco_01,
deuda_bco_02,
deuda_bco_03,
deuda_bco_04,
deuda_bco_05);
val = 1;
Return val;

End If;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

a la hora de llamarlo desde mi codigo en java, enviando los parametros me
arroja el siguiente error:

select * from
sp_insert_cabezera_sbs(?,,0045275213,2007-11-30,,,1,07087112,1,002,0.0,0.0,
0.0,0.0,100.0,0.0,,ABARCA,,CARLOS,LUIS,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,
0.0,0.0,0.0,0.0,,,,,,,0.0,0.0,,0.0,0.0,0.0,0.0,0.0,0.0) as result
org.postgresql.util.PSQLException: ERROR: function
sp_insert_cabezera_sbs(character varying, character varying, character
varying, character varying, character varying, character varying, character
varying, character varying, character varying, double precision, double
precision, double precision, double precision, double precision, double
precision, character varying, character varying, character varying,
character varying, character varying, double precision, double precision,
double precision, double precision, double precision, double precision,
double precision, double precision, double precision, double precision,
double precision, double precision, double precision, character varying,
character varying, character varying, character varying, character varying,
character varying, double precision, double precision, character varying,
double precision, double precision, double precision, double precision,
double precision, double precision) does not exist

segun lo que entiendo quizas algun parametro este mal tipado o no esten
correctos el numero de parametros pero como les dije ya revise varias veces
y aparentemente tego los parametro correctos.

Quizas alguno de Uds me pudiera ayudar. De antemano les agradezco la ayuda
prestada.

Saludos.

--
NachXs
http://nachxs.blogsome.com

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Milton Galo Patricio Inostroza Aguilera 2008-01-05 05:21:44 Re: Ayuda con Funcion
Previous Message Oscar Cano 2008-01-05 00:43:37 Re: Seguridad de la informacion