Session s=this.getSessionFactory().openSession();
Connection con=s.connection();
String procedure = "select * from fmt( ' "+companyid+ " ') ";
stmt = con.prepareCall(procedure);
stmt.execute....