Re: error in function!!

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