pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feederror in function!!
2+ messages / 2 participants
[nested] [flat]
* error in function!!
@ 2005-01-31 18:59 Ing. Jhon Carrillo <jdigital@cantv.net>
2005-02-01 04:42 ` Re: error in function!! John DeSoi <desoi@pgedit.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ing. Jhon Carrillo @ 2005-01-31 18:59 UTC (permalink / raw)
To: 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!!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: error in function!!
2005-01-31 18:59 error in function!! Ing. Jhon Carrillo <jdigital@cantv.net>
@ 2005-02-01 04:42 ` John DeSoi <desoi@pgedit.com>
0 siblings, 0 replies; 2+ messages in thread
From: John DeSoi @ 2005-02-01 04:42 UTC (permalink / raw)
To: Ing. Jhon Carrillo <jdigital@cantv.net>; +Cc: pgsql-sql
On Jan 31, 2005, at 1:59 PM, Ing. Jhon Carrillo wrote:
>
> 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?
>
This message is telling you that your function call using
tschema.sp_actualizar_contacto was not correct. You must have all
parameters in the function call and they must all be the correct type.
So the message above says the first parameter passed was an integer,
but your function expects the first parameter to be text.
Note that you can remove all of the ALIAS declarations and use
parameter name directly.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-02-01 04:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-31 18:59 error in function!! Ing. Jhon Carrillo <jdigital@cantv.net>
2005-02-01 04:42 ` John DeSoi <desoi@pgedit.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox