Ver Mensaje Individual
  #1 (permalink)  
Antiguo 20/01/2007, 02:25
Avatar de Nighter
Nighter
 
Fecha de Ingreso: enero-2007
Mensajes: 97
Antigüedad: 17 años, 10 meses
Puntos: 0
Pregunta problema con sp en postgresql

saludo, disculpen tengo el siguiente codigo y me manda este error, me podrian decir cual es el problema?, de antemano gracias

SP y ejecucion:
Código:
-- Function: oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying)

-- DROP FUNCTION oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying);

CREATE OR REPLACE FUNCTION oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying)
  RETURNS void AS
$BODY$BEGIN
  INSERT INTO oots.users VALUES(nick_, pass_, name_, email_, cel_, t_user_, birth_, address_, city_);
  COMMIT;
END$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying) OWNER TO nighterpgsa;
Error:
Código:
ERROR: function oots.adduser("unknown", "unknown", "unknown", "unknown", "unknown", boolean, "unknown", "unknown", "unknown") does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You may need to add explicit type casts.
Character: 8