20/01/2007, 02:25
|
| | | Fecha de Ingreso: enero-2007
Mensajes: 97
Antigüedad: 17 años, 10 meses Puntos: 0 | |
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
|