Re: Ayuda con Funcion

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