Re: Ayuda con Funcion

Bueno ya solucione el problema, aparentemente tenia problemas en el tipado,
dado que yo estaba mandando parametros de tipo Double y las variables de mi
funcion estaban con numeric.

Igual gracias por la atencion.

Saludos

2008/1/5, Milton Galo Patricio Inostroza Aguilera <minoztro(at)gmail(dot)com>:
>
> 2008/1/5, NachXs <nachxs(at)gmail(dot)com>:
> > 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
>
> al parecer debes llamar a la función de la siguiente manera:
>
> select sp_insert_cabezera_sbs(...............tus argumentos...)
>
>
> es decir no poner * from.
>
> > 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
>
>
> --
> Milton Inostroza Aguilera
>

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