From: | "Ing(dot) Jhon Carrillo" <jdigital(at)cantv(dot)net> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | error in function!! |
Date: | 2005-01-31 18:59:12 |
Message-ID: | 009901c507c7$01d882e0$1400a8c0@tgusta2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
i have a problem with the following sentence:
CREATE OR REPLACE FUNCTION tschema.sp_actualizar_contacto(p_idpers text,
p_nombre text,
p_apellido text,
p_titulo text,
p_fecnac text,
p_codedociv integer,
p_sexo text,
p_codpais integer,
p_pw text,
p_empr text,
p_cargo text,
p_pwempr text,
p_aniv text,
p_prof text,
p_trab text,
p_fecgen text,
p_fecing text,
p_fuente text,
p_codupload integer,
cli_codigo integer ) RETURNS text as '
DECLARE
c_codigo integer;
c_sinc varchar;
c_idpers ALIAS for $1;
c_nombre ALIAS for $2;
c_apellido ALIAS for $3;
c_titulo ALIAS for $4;
c_fecnac ALIAS for $5;
c_codedociv ALIAS for $6;
c_sexo ALIAS for $7;
c_codpais ALIAS for $8;
c_pw ALIAS for $9;
c_empr ALIAS for $10;
c_cargo ALIAS for $11;
c_pwempr ALIAS for $12;
c_aniv ALIAS for $13;
c_prof ALIAS for $14;
c_trab ALIAS for $15;
c_fecgen ALIAS for $16;
c_fecing ALIAS for $17;
c_fuente ALIAS for $18;
c_codupload ALIAS for $19;
cli_Codigo ALIAS for $20;
BEGIN
select nextval(''seq_tbu_contacto_cont_codigo'') into c_codigo;
Insert into tbu_contacto (cont_codigo, cont_idpers,cont_nombre,cont_apellido,cont_titulo,cont_fecnac,cont_codedociv,cont_sexo,cont_codpais,cont_pw,cont_empr,cont_cargo,cont_pwempr,cont_aniv,cont_prof,cont_trab,cont_fecgen,cont_fecing,cont_fuente,cont_sinc,cont_codupload) values (c_codigo,c_idpers,c_nombre,c_apellido,c_titulo,to_timestamp(c_fecnac,''YYYY-mm-dd HH:MM:SS''),c_codedociv,c_sexo,1,c_pw,c_empr,c_cargo,c_pwempr,c_aniv,c_prof,c_trab,to_timestamp(c_fecgen,''YYYY-mm-dd HH:MM:SS''),to_timestamp(CURRENT_TIMESTAMP,''YYYY-mm-dd HH:MM:SS'') ,c_fuente,''S'',c_codupload);
return ''OK:''||c_codigo;
END;
' LANGUAGE 'plpgsql'
this is the error in pgadmin III on windows (postgresql 8.0):
ERROR: function tschema.sp_actualizar_contacto(integer, "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", integer, integer) does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
I need to know if the "insert sentence" was sucesfull, how do i do?
help me with this please,
thanks!!
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F.O'Connell | 2005-01-31 20:25:03 | Re: plpgsql functions and NULLs |
Previous Message | Don Drake | 2005-01-30 19:41:28 | plpgsql functions and NULLs |