Hibernate动态创建视图

create or replace procedure pro_view_TblAutoAnalyse(queryPara varchar2,orderSort varchar2) is
querySql varchar2(1000);
begin
   querySql := 'create or replace view  v_TblAutoAnalyse as select * from tbl_auto_analyse where 1=1 ';
   if queryPara is not null then
     querySql := querySql ||  queryPara;
   end if;
   if orderSort is not null then
     querySql := querySql ||  orderSort;
   end if;
   EXECUTE IMMEDIATE querySql;
end pro_view_TblAutoAnalyse;


/**
* 根据条件创建动态视图
* @param valueMap
* @throws Exception
*/
private void createDynamicView(HashMap valueMap)throws Exception{
Session session = hibernateTemplate.getSessionFactory().openSession();
Connection conn = session.connection();  
CallableStatement call = conn.prepareCall("{Call pro_view_TblAutoAnalyse(?,?)}");
call.setString(1, valueMap.get("soc_sql")==null?"":valueMap.get("soc_sql").toString());
call.setString(2, valueMap.get("soc_orderby")==null?"":valueMap.get("soc_orderby").toString());
call.executeUpdate(); 
session.close(); 
}