From: | "Alexander Quilca" <alquilca(at)hotmail(dot)com> |
---|---|
To: | <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Insercion con funciones |
Date: | 2006-09-06 22:57:22 |
Message-ID: | BAY123-DAV14145EC73440F0F54DE685C1310@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Srs. tengo la siguiente funcion que tiene que insertar informacion en una
tabla
CREATE OR REPLACE FUNCTION "FN_I_CAB_CCC" (pano_eje varchar,pnro_ccc varchar
,pnro_sol varchar ,pcod_sec varchar ,pfch_ccc timestamp ,pcod_tar varchar
,pctr_cos varchar ,pgls_ccc text ,pflg_anu boolean ,pfch_anu timestamp
,pinf_reg text)
RETURNS varchar
AS
$body$
DECLARE
BEGIN
insert into "CAB_CCC"(ano_eje,nro_ccc, nro_sol , cod_sec , fch_ccc ,
cod_tar , ctr_cos , gls_ccc , flg_anu , fch_anu , inf_reg)
values (pano_eje ,pnro_ccc,pnro_sol , pcod_sec , pfch_ccc ,
pcod_tar, pctr_cos , pgls_ccc , pflg_anu , pfch_anu , pinf_reg);
RETURN 1;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
La función corre perfectamente, pero al llamar a la función me sale el
siguiente el error:
select * from "FN_I_CAB_CCC"( '2006' ,'00000365','00000000',NULL
,now(), '0008' ,NULL ,NULL, false ,now() ,'')
ERROR: function FN_I_CAB_CCC("unknown", "unknown", "unknown", "unknown",
timestamp with time zone, "unknown", "unknown", "unknown", boolean,
timestamp with time zone, "unknown") does not exist
HINT: No function matches the given name and argument types.
Espero sus comentarios, para solucionar este problema
Gracias
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-09-06 23:16:21 | Re: Insercion con funciones |
Previous Message | Linder Poclaba | 2006-09-06 22:06:55 | Re: Malformed function or procedure escape syntax at offset 1. |