Insercion con funciones

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

In response to

Responses

Browse pgsql-es-ayuda by date

  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.