-- Function: createtable(text)

-- DROP FUNCTION createtable(text);

CREATE OR REPLACE FUNCTION createtable(text)
  RETURNS numeric AS
$BODY$
BEGIN

EXECUTE 'Create table '||$1||'()';
return 0;   
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION createtable(text)
  OWNER TO postgres;

String hql= "select createTable() from XTable ";
        Query query = session.createQuery(hql);
       
        List list = query.list();
       
        String nextValue = (String)list.get(0).toString();
        System.out.println(nextValue);

Connection con = session.connection();  // obtain JDBC connection from Session object
        CallableStatement cs = con.prepareCall("{? = call createTable('XYZ') }");
        cs.execute();  // call function