Call sql function in psql

Hi All,

Please send me some info how to post directly in mailing
list,somwhow I am not able to find out the way so I am mailing here.

Present problem--

I tried to change below code in psql —

Session sess = (Session) entityManager.getDelegate();

sess.createSQLQuery("{ call reset_all() }").executeUpdate();

Here 'sess' is org.hibernate.Session and reset_all() is a function which
contains—

DECLARE

username varchar(30);

BEGIN

select user into username;

if username like 'XXXXX%' then

update YYYYY set aaaa = 0;

update ZZZZ set bbbb= 0;

EXECUTE('truncate table abc');

EXECUTE('truncate table def');

::::::::::::::::::::::::::::::::::::::::::::::::

else

RAISE NOTICE 'User not allowed to run this procedure';

end if;

end;

I tried to modify like

sess.createSQLQuery("select reset_all()").executeUpdate();

getting error -- org.postgresql.util.PSQLException: A result was returned
when none was expected.

What should be the syntax of calling reset_all().

Thanks and Regards,

Abhra