I have function like this :
CREATE OR REPLACE FUNCTION f_insert_account(usernames character varying, passwds
character varying, identitass integer, jeniss smallint, statuss smallint, cnames
character varying, unames character varying)
RETURNS character varying AS
$BODY$
DECLARE
iduserx int4;
usernamex varchar;
er int2:=0;
pesan varchar:='';
BEGIN
insert into t_account(username,passwd,identitas,jenis,status,cname,uname)
values(usernamex,f_encr(passwds),identitass,jeniss,statuss,cnames,unames);
RETURN pesan;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION f_insert_account(usernames character varying, passwds character
varying, identitass integer, jeniss smallint, statuss smallint, cnames character
varying, unames character varying) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION f_insert_account(usernames character varying, passwds
character varying, identitass integer, jeniss smallint, statuss smallint, cnames
character varying, unames character varying) TO public;
GRANT EXECUTE ON FUNCTION f_insert_account(usernames character varying, passwds
character varying, identitass integer, jeniss smallint, statuss smallint, cnames
character varying, unames character varying) TO postgres;
then I use that like this :
select f_insert_account('dayat', 'dayat', 1, 1, 1, 'cname', 'uname')
Error like this always appear : ERROR: function f_insert_account("unknown", "unknown", integer, integer, integer, "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
why is that ???
thanx,
Dayat
f_insert_account()
and then complain about errors withf_account_sp()
. Please clarify. – Erwin Brandstetter Nov 17 '11 at 6:28